View Single Post
  #2  
Old March 4th, 2010, 07:11 PM posted to microsoft.public.access.forms
Daryl S[_2_]
external usenet poster
 
Posts: 881
Default Excel Type Rounding

Anand -

Try this:

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

--
Daryl S


"Anand" wrote:

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