Chart within a Report

  • Thread starter Thread starter Ronald M. Kozak
  • Start date Start date
R

Ronald M. Kozak

I have created a report using 2 different queries (i.e.,
RF Issues Query and RF Chart Query). I want for both the
report and the chart to display information within a
certain date range (i.e., >=[Enter Beginning Date] And <=
[Enter Ending Date]). The problem that I am having is
that only the report will show the information within the
date range and the chart shows information of the entire
table. I went into the Row Source of the chart and
entered in parameters to try and correct this with no
help (Row Source Type: Table/Query Row Source:
PARAMETERS [Enter Beginning Date] DateTime, [Enter Ending
Date] DateTime; TRANSFORM Count(*) AS [Count] SELECT [RF
Chart Query].Area FROM [RF Chart Query] GROUP BY [RF
Chart Query].Area PIVOT [RF Chart Query].Expr1;). When I
ran the report it asked for Enter Beginning Date and
Enter Ending date 3 time. After entering in the
information the result was the same. Can anyone help me
with this or would it be possible if I sent you a zipped
file with the database so that this problem can be
resolved? I am desperate to get this project finished
and this is the last step that I need in order to finish
it.

Thank you,
Ron
 
Don't use parameter prompt queries. Use references to text boxes (or other
controls) on forms. Your where clause in your row source and record source
would be
Where [DateFieldName] Between Forms!frmA!txtStart and Forms!frmA!txtEnd

Your row source for the graph doesn't suggest a where clause. I assume "RF
Chart Query" has parameter prompts?
 
Back
Top