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
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
