Report with sub-report and chart

  • Thread starter Thread starter Darla
  • Start date Start date
D

Darla

I created a report...probably not the best way...it has a
sub report on one side that list a breakdown of
information for my chart and on the right side is a pie
chart. Each is based on it's own query. In each query I
have criteria in a field asking for Between[beginning
date] and [ending date]. This allows you to pick the dates
needed. When I open the report it ask for the dates for
the subreport and then again for the chart.

Is there a way I can enter the dates needed in one form
and have it select the information needed out of both
queries? Can I just reference the form field in both
queries? I'm sure my problem is just too much thinking.

Thanks for any help.
 
Hi.
The best way to accomplish this is to create a form with
two unbound text boxes containing the startdate and enddate
That you can refer the underlying queries to these boxes
using:
forms!ParamForm!startdate
etc.
Hope this helps.
Fons
 
Back
Top