My ultimate goal is to build a report (Chart) which is based on a query.
I've got the query going. I've got the chart report going.
My next step is to be able to modify the query so that I can re-use the
same report for the various instances of the report.
My Query:
SELECT Format([Date Arrived in PCC],"mm/yyyy") AS DateArrivedInPCC,
Avg(Format(WorkDays([Date Arrived in PCC],[ECO Routing
Complete]),"#,###.0")) AS WorkDays
FROM tblReleases
GROUP BY Format([Date Arrived in PCC],"mm/yyyy"), tblReleases.[ECN
Class]
HAVING (((tblReleases.[ECN Class])=[Forms]![frmECNClass]![ECN Class]))
ORDER BY Format([Date Arrived in PCC],"mm/yyyy");
My Report will work IF I change the query to:
SELECT Format([Date Arrived in PCC],"mm/yyyy") AS DateArrivedInPCC,
Avg(Format(WorkDays([Date Arrived in PCC],[ECO Routing
Complete]),"#,###.0")) AS WorkDays
FROM tblReleases
GROUP BY Format([Date Arrived in PCC],"mm/yyyy"), tblReleases.[ECN
Class]
HAVING (((tblReleases.[ECN Class])="3"))
ORDER BY Format([Date Arrived in PCC],"mm/yyyy");
However, if I leave the query setup the way I want it, the report
provides an error:
"The Microsoft Jet database engine does not recognize
'Forms!frmECNClass![ECN Class]' as a valid field name or expression."
I hope I don't have to build a separate report for each of the ECN
Classes.
The OLEUnbound Object Frame - Microsoft Graph chart has the following as
it's RowSource:
TRANSFORM Avg([WorkDays]) AS [AvgOfWorkDays] SELECT [DateArrivedInPCC]
FROM [qryWorkDays] GROUP BY [DateArrivedInPCC] PIVOT [WorkDays];
It seems as though I should be able to change [qryWorkDays] to a Select
Statement, but I have not been able to figure out the syntax.
Dawn Crosier
Application Specialist
"Education Lasts a Lifetime"
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> 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/
