davetough
asked on
create query to search back a year
Hello,
i have attached a small sample of data.
Is there a way to create a query for this data and find avg daily quantity used based on the field [qty installed]?
problem I have is first how do I join and group data and keep dates?
second can a query say look back a year from today and create daily average based on it?
thank you
Database1.accdb
i have attached a small sample of data.
Is there a way to create a query for this data and find avg daily quantity used based on the field [qty installed]?
problem I have is first how do I join and group data and keep dates?
second can a query say look back a year from today and create daily average based on it?
thank you
Database1.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you
Hi
Is this what you mean? There's one query that collects only the rows up to 365 days old based on the current system date. Then I have added two queries that use the first query's results. One gives an average of all units (i.e. 234 "somethings") and the other finds the average per description (which would be really better expressed with a definite "category" ID to ensure spelling variances don't confuse things)