Format number derived from average in query

  • Thread starter Thread starter thompmc
  • Start date Start date
T

thompmc

I am trying to find the average of age from a table wherein age is formated
with 0 decimals. How does one specify the average to show no decimal points?
 
Use the Round function or Int function (if you want to truncate the value)

Round(Avg(AGE),0)

Int(Avg(Age))


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 

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 in a report question 2
How do change the decimal in a formula? 5
Calculation in Update query drops decimal places 2
decrease numbers after decimal in "average" 1
Rounding Question 5
PivotChart Decimal Place on Fixed Number Format on Averaged Field 4
Access stripping decimal places in query 1
0 Decimal places/round function. 4

Back
Top