Rounding numbers to thousands

[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?

 

[Maciek Paras]

Set properties of that field to "fixed" and numer of decimal places to 3.

 

[Guest]

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