Rounding numbers to thousands

M

Mike

I have a query which retrieves amounts in currency format.
I need those amount to be rounded to 3 digits left to
decimal place.
For example: 1,222,222.23 should be rounded as 1,222
or 5,222,777.23 - as 5,223

Is it possible?
 
G

Guest

Assuming you want to show how many thousands then divide
by 1000 and set format to fixed with no decimal places.
 
Top