We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

create query to search back a year

davetough
davetough asked
on
Medium Priority
258 Views
Last Modified: 2012-06-27
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
Comment
Watch Question

Database1.accdb

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)
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
thank you
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.