Format number derived from average in query

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?
 
J

John Spencer

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
 
Top