Rounding to the nearest Thousand

  • Thread starter Thread starter Jane
  • Start date Start date
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?
 
CLng(Input/1000) * 1000

should do. For example, from Debug window:

?CLng(123456789/1000) * 1000
123457000
 
Back
Top