avg calculation

[dumdum2]

I have a table of records, some with an age, some where age is blank. I'd like to get the average age of all the records combined, and I would usually export to Excel and do the formula in Excel. But I'd like to figure how to get Access 2000 to do it for me......

Thanks!

 

[PHV]

Something like this (SQL code) ?
SELECT Avg([age field]) AS averageAge
FROM yourTable

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Golom]

Just

Select AVG([Age]) As [Average Age], ...

From myTable

Which will ignore those records where Age is NULL.