G Guest Jun 9, 2005 #1 I need to round up/down demical, eg .57 would be .55 .28 would be .30 any ideas?
A Allen Browne Jun 9, 2005 #2 Access 2000 and later have a Round() function. To round to the nearest 5c, double the value, round to 1 decimal place, and half the result: =Round([Amount] * 2, 1) / 2 If you are working with an older version of Access, see: http://www.mvps.org/access/modules/mdl0054.htm
Access 2000 and later have a Round() function. To round to the nearest 5c, double the value, round to 1 decimal place, and half the result: =Round([Amount] * 2, 1) / 2 If you are working with an older version of Access, see: http://www.mvps.org/access/modules/mdl0054.htm
