Reports and Graphs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with graphs based on a query. When I hard code the date
range for the report - it works correctly. When I put in paramters for the
user to enter in the dates ([Start Date] and [End Date]) and run the report
it asks for the Start and End dates 3x for every entry in the query.
Any suggestions?
 
in message:
I have a report with graphs based on a query. When I hard code the date
range for the report - it works correctly. When I put in paramters for the
user to enter in the dates ([Start Date] and [End Date]) and run the report
it asks for the Start and End dates 3x for every entry in the query.
Any suggestions?
Click to expand...

Hi Patricia,

This is one of the drawbacks of using query parameter prompts to feed
your report values. The best thing to do is to build a custom form that
will allow your users to enter the Starting and Ending date values in text
box controls. By doing it this way your "Print" button could first verify
the dates by checking, for example, if the end date is before the start date.
Your query that feeds the report can simply use a criteria of:
Between [Forms]![frmNameOfForm]![txtBeginDate] And
[Forms]![frmNameOfForm]![txtEndDate]

Your report itself could also pull those values into text box controls
by referencing the same form fields. No more prompts and better
control will follow by using this approach.
 
Back
Top