How to format value of a query output

[mrchonginhk]

I have an Access Query that returns number as output like 1234.
How can I make sure it returns 1,234 instead ?

Thanks

 

[SydneyGeek]

In the query design right-click in the grid below the field, and select Properties. You can set the format there.

Denis