If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|