Query Field formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

I've created a select query and I am using the avg group by function. My
averages are working correctly but I want to see the results as a whole
standard
number in the query field. I can't quite get the format verbage right. Any
solutions?

Thanks to all who reply!!!!!!

Bruce DiPaola
 
Try

Format([FieldName], "##,##0.00")

If you don't want decimal places remove the zero's
Format([FieldName], "##,##0")
 
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

Average format 1
Query field formatting 1
Parameter Query 2
Need Help-Combo Box headache 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Concatenate Date and Number field for Append Query 0
Entering measurements in a field 2
Avg expression in a query 4

Back
Top