Rounding to thousands

  • Thread starter Thread starter Fabio
  • Start date Start date
F

Fabio

My query results are a column with numbers like
$10,385.00, $134,235.23. How can I give them a format to
round up to the thousands or better five hundreds? Like,
$10,500, $134,000 ... Thanks in advance, FABIO
 
Do you want to round up to the nearest 500 or round to the nearest 500?

Round up
-Int(-10185.00/500)*500 -->> 10500
Round
CLng(10185/500)*500 -->> 10000

Also, if you are using Access 2k or later I believe there is a rounding function available
 
Back
Top