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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Roundup Function 1
Rounddown 3
How do I roundup to .9 and rounddown to .9 3
Rounddown Numbers 2
I need an Excell function similar to Roudup for Access. 1
Query Functions 2
rounddown + if function 8
Using ROUNDDOWN - Help please 3

Back
Top