round a value in access to nearest thousand

[Cathy]

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

 

[Allen Browne]

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.

 

[Cathy]

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