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

[Guest]

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

 

[Guest]

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.