Chart within a Report

[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

 

[Duane Hookom]

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?