Query Formatting

  • Thread starter Thread starter Trisha
  • Start date Start date
T

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
 
If you go to the properties for that column in the query
you can format with as many decimal places as needed.

Jim
 
Back
Top