ROUND to nearest 1000

  • Thread starter Thread starter Alex Brown
  • Start date Start date
A

Alex Brown

I am trying to round numbers to the nearest 1000 in a
query. When I use the ROUND function and put "-3" for the
number of digits:

ROUND(number,-3)

I get the following message:

Invalid Procedure Call

Can anyone help?

Thanks,
Alex
 
Hi Alex,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

The following Knowledge Base article should get you started in the right
direction:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209996

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding to nearest 1000 10
in access, round up to nearest fraction(.5) 1
round to nearest 5 2
I need to always Round UP if greater than zero at all. HOW? 6
rounding to closest 15 minute increment 1
rounding nearest 10 2
round to nearest 114 2
Round Number to the nearest 1/8 th 2

Back
Top