Excel Type Rounding

[Anand]

Hello,
Am using A2k. Want to round numbers to thousands. With Excel I use
Round(number, -3) for this. However, dont know how to do it with Access
standard Round() function. The same syntax produces an error with Access. Pls
Help

For example, I want 125,232 to be displayed as 125,000 and 125,832 to be
displayed as 126,000

TIA
Anand

 

[Daryl S]

Anand -

Try this:

Round([AmountToRound]/1000,0)*1000