Excel Type Rounding

  • Thread starter Thread starter Anand
  • Start date Start date
A

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
 
Back
Top