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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating Issue in a Query 1
Access stripping decimal places in query 1
Formatting decimal places 8
Excel Excel 2007 won't stop rounding down my formula results! 5
Formatting a calculated field in a query 1
format a number field to only show 2 decimal places if there are a 6
Currency 2
Where/how to set rounding property for a Query field 7

Back
Top