Query Formatting

[Trisha]

I would like to format two columns in my query, if
possible. They are pretty simple, but in one column I do
a calculation in order to get a total cost. Would it be
possible to format this to be currency with two decimal
places?

Also, can I format another column to contain 3 decimal
places and that's it?

Thanks for your help,
Trisha

 

[Jim/Chris]

If you go to the properties for that column in the query
you can format with as many decimal places as needed.

Jim