View Single Post
  #1  
Old March 4th, 2010, 05:16 PM posted to microsoft.public.access.forms
Anand
external usenet poster
 
Posts: 63
Default Excel Type Rounding

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