Gustav Brock
gustav at cactus.dk
Fri May 7 13:32:27 CDT 2004
Hi Mark > A user has asked me to remove the "cents" from several currency fields. > Instead of reformatting the fields, I'd like to round the amounts to the > nearest dollar. Is there a query I can run that will round in this > manner? The quick and dirty (Access 2000+) is Round([Amount], 0) It's a little buggy. If you need serious rounding, visit: http://www.xbeat.net/vbspeed/c_Round.htm and browse for Round15. /gustav