Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2001
    Thanked 0 Times in 0 Posts

    Rounding (Access 97)

    I'm looking for a way to take 3 numbers and round them to the nearest .25". The Round function works differently than in Excel (Excel allows =ROUND((SUM(G9,H9,I9)/3)*4,0)/4 - messy but it works)

    Excel also allows lookup tables which could be used when the last switch is true (meaning that exact matches are not necessary - anything up to X value is returned). Not exactly the same as the nearest .25", but would be fine. Tried finding a way to do this with Dlookup, but didn't find a way to eliminate the need for an exact match.

    I could get into VBA and write a select statement off of a X mod Y to determine if the remainder is < .25, < .5, ... but I'm guessing there is a better way.

    Any suggestions?

    Thanks for the help.

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Newbury, Berkshire, England
    Thanked 0 Times in 0 Posts

    Re: Rounding (Access 97)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts