Can I use the "RoundUp" and "RoundDown" functions in Access?

M

Mike

I'm trying to Round Up and Round Down the decimal results on an access
report. Is anything available to allow me to do this? I know that it is
available in Excel, but I haven't been able to figure it out in Access?

Any recommendations would be appreciated.

Thanks.....Mike
 
E

Eric Blitzer

The function in access is
Rnd(fieldname)
If you don't like that you could create your own rounding function.
Ken Getz has provided one that allows you to optionally turn on/off this
"banker's rounding":
http://www.mvps.org/access/modules/mdl0054.htm
Be sure to rename it so it doesn't fight with the built-in one.
 
Top