RE: [AccessDevelopers] Having a Query Group by Month

Wed, 04 Jan 2006 09:19:41 -0800

Tom -
 
Thank you, that was just what I needed to get my brain jump started. <smile>

Dawn Crosier
Application Specialist
"Education Lasts a Lifetime"

From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Tom Oakes
Sent: Wednesday, January 04, 2006 10:27 AM
To: AccessDevelopers@yahoogroups.com
Subject: RE: [AccessDevelopers] Having a Query Group by Month

Do you need the [ECO Routing Complete] field in your query?  If not:
 
SELECT 
Format(tblReleases.[Date Arrived in PCC], "mmm yyyy") As TheMonth,
Avg(WorkDays([Date Arrived in PCC],[ECO Routing Complete])) AS WorkDays
FROM tblReleases;
 
if so..
 
SELECT 
Format(tblReleases.[Date Arrived in PCC], "mmm yyyy") As TheMonth,
tblReleases.[ECO Routing Complete],
Avg(WorkDays([Date Arrived in PCC],[ECO Routing Complete])) AS WorkDays
FROM tblReleases
GROUP BY tblReleases.[ECO Routing Complete];
 
Those are off the top of my head, but hopefully you get the idea.
 

Tom Oakes
Personal PC Consultants, Inc.
[EMAIL PROTECTED]
503.230.0911 (O)
402.968.6946 (C)
734.264.0911 (F)



From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Crosier, Dawn
Sent: Wednesday, January 04, 2006 7:42 AM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] Having a Query Group by Month

OK, I must have gone brain dead over the holiday.  I have a query that I
have started, and I need to get to the next step.

SELECT tblReleases.[Date Arrived in PCC], tblReleases.[ECO Routing
Complete], WorkDays([Date Arrived in PCC],[ECO Routing Complete]) AS
WorkDays
FROM tblReleases;

I need to convert the above query so that it shows me the Average Number
of Working Days By Month, based on the Date Arrived in PCC.

I know I need to convert the query to a GroupBy - with WorkDays =
Average, but how do I write the _expression_ for the date fields?

Dawn Crosier
Application Specialist
"Education Lasts a Lifetime"


Please zip all files prior to uploading to Files section.


YAHOO! GROUPS LINKS



Reply via email to