[AccessD] Rounding Currency

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




More information about the AccessD mailing list