round a value in access to nearest thousand

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

Guest

I am designing a wages/salary access database and I need to be able to round
their salaries/wages to the nearest 1000 - up or down. Does someone know how
to do this

Thanks

Cathy
 
Copy the function from this link:
http://www.mvps.org/access/modules/mdl0054.htm

If you are using Access 2000 or higher, rename it so it does not clash with
the built-in Round() function.

You can now round to -3 decimal places, e.g.:
? Round(9999, -3)

Unfortunately, the Round() function built into Access is broken and cannot
accept negative powers of 10.
 
Hi Allen

Thank you so much for the help - I apologise for not writing sooner but my
internet connection has been down all this time (Zimbabwe!!) - I will try
this now

Thanks again

Cathy
 
Back
Top