Rounding to the nearest Thousand

J

Jane

I'm trying to create an expression in a query that will
round a currency number to the nearest thousand dollars.
The Round()function only seems to want to round numbers on
the right side of the decimal point, not on the left. The
Excel techniques of using a negative number to define the
precision level only results in an #Error message. Is
there a means to accomplish this?
 
V

Van T. Dinh

CLng(Input/1000) * 1000

should do. For example, from Debug window:

?CLng(123456789/1000) * 1000
123457000
 

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

How do I round to the nearest thousand? 1
Preventing rounding numbers to nearest dollar 2
Access 2007: % fields rounding to nearest integer 3
Rounding up to the nearest .25 1
Round to nearest quarter 5
Rounding 10
rounding figures to nearest thousand 3
Round to nearest 10,000 2

Top