Really simple query statistics question

[osp001]

I'm trying to get a query to display the average age of a product for which I have a manufacturing date (fill_date) and a disposal date (termination_date). It's been a while since I've worked with Access, so I forget how to subtract one from the other in a query (in design view, if possible) so I can get the average age of all these containers. Any help?

 

[r937]

add this to your query's SQL ...

SELECT ...
, AVG(DATEDIFF("d",fill_date,termination_date)) AS avg_age_in_days
, ....

and then switch over to design view to see it there



r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[dhookom]

osp001,
"Containers" or "product" or something else?
Age expressed in what (hours, days, months, years,...)?
Can you share significant table and field names?

I expect your query would be a basic totals query with an expression similar to r937's suggestion.


Duane
Hook'D on Access
MS Access MVP

 

[lespaul]

and don't forget to add the GROUP BY clause for all the non-aggregate fields in your SELECT

Leslie