ROUND to nearest 1000

[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

 

[Dennis Schmidt]

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