AVG BETWEEN DAYS

Lucy

Guest

Posts: n/a

4th Jun 2010

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.

« querying unrelated tables | DatePart »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need to pull <=14 Days, <=30 Days, >30 Days from a date column	Ken	Microsoft Excel Misc	3	23rd Oct 2009 12:53 AM
Networking days, weekends, holidays and delivery days cancelled	D-Lys	Microsoft Access Queries	5	17th Mar 2009 09:00 PM
Employee days worked (-Holidays, -weekends, Snow Days, etc)	Denise	Microsoft Excel Misc	1	31st Dec 2008 04:37 PM
Why is it taking days to copy 80gigs from internal to external USBdrive takes days	acvendingny@gmail.com	Storage Devices	4	24th Feb 2008 04:24 PM
Day of week is not displayed in day, 5 days or 7 days views in Outlook 2003 SP2 (french)	Tartempion	Microsoft Outlook Discussion	4	22nd Feb 2007 02:38 PM