View Single Post
  #1  
Old June 4th, 2010, 09:03 PM posted to microsoft.public.access.queries
Lucy
external usenet poster
 
Posts: 103
Default AVG BETWEEN DAYS

Hello,
Within my qry I would like to calculate the average daily production for the
month.
The data Im working with is: production volume, dates (which is a daily
info.) and ID number. I'm working with tons of data that have production for
each day of the year dating back 5 or more yrs. However I'd like to narrow
my daily data to only 6months prior summed up to monthly data and averaged.
Please help!
Thanks for your help.