ROUND to nearest 1000

ROUND to nearest 1000

Post by Alex Brow » Wed, 17 Sep 2003 01:26:00

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:


I get the following message:

Invalid Procedure Call

Can anyone help?


ROUND to nearest 1000

Post by DennisOnLi » Wed, 17 Sep 2003 09:16:52

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: ;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 ;.

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

Dennis Schmidt
Microsoft Support