Chart within a Report (Access 2003)

  • Thread starter Thread starter Ron Kozak
  • Start date Start date
R

Ron Kozak

I built a report using 2 different queries. RF Issues
Query: SQL Statement (SELECT [RF Issues].Area, [RF
Issues].Date, [RF Issues].SerialNumber, [RF
Issues].SoftwareIssue, [RF Issues].PhysicalIssue, [RF
Issues].GunNumber, [RF Issues].ReportedBy, IIf
([SoftwareIssue],"Software","Physical") AS Expr1
FROM [RF Issues]
WHERE ((([RF Issues].Date)>=[Enter Beginning Date] And
([RF Issues].Date)<=[Enter Ending Date]) AND (([RF
Issues].SoftwareIssue) Is Not Null) AND (([RF
Issues].PhysicalIssue) Is Not Null))
ORDER BY [RF Issues].Area, [RF Issues].Date, [RF
Issues].GunNumber;)

And RF Chart Query: SQL Statement (SELECT [RF
Issues].Area, IIf([SoftwareIssue],"Software","Physical")
AS Expr1
FROM [RF Issues];)

I need for my chart to look at the information in the
report. I have the report setup to lookup information
within a date range. The chart however will show
everything. When I try to enter a date range for a chart
I get an error message: The Microsoft Jet database engine
does not recognize '[Enter Beginning Date]' as a valid
field name or expression.

Sorry this is so long. I just thought the more info I
gave the better someone could help me out.

Thanks,
Ron
 
Ron:

If you have have parameters in your reports query e.g. [Enter Beginning
Date] and [Enter Ending Date], then you can also add these paramteters to
your report as controls by simply setting the control source to = [Enter
Beginning Date] etc.

Once the control is on the report (say named BeginDate), then your Graph can
reference the report control so that your graph query would have a condition
of Between Report.[BeginDate] and Report.[EndDate].

If you have on graph object per date, then you could use the link master /
link child property of the graph control to limit the graph to a specific
date for the current record in your report.
 
Back
Top