Have you tried using a "query def" to modify the underlying query to the
report?
"Crosier, Dawn" <[EMAIL PROTECTED]> wrote: 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"
SPONSORED LINKS
Microsoft access database Database development software Database
management software Database software Inventory database software
Membership database software
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "ms_access" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us
---------------------------------
Yahoo! DSL Something to write home about. Just $16.99/mo. or less
[Non-text portions of this message have been removed]
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/
