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
 
Back
Top