RE: [AccessDevelopers] Having a Query Group by Month

Wed, 04 Jan 2006 08:24:20 -0800

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.



SPONSORED LINKS
Microsoft access developer Microsoft access help Microsoft access database
Microsoft access training Microsoft access training course Microsoft access programming

YAHOO! GROUPS LINKS



Reply via email to