Start and End Date on Report

[Prufrock]

Hi,

I have a report which is based on a query. When it is run the user has to enter a Start Date and an End Date to cover the range of the report. How can I get the report to print the start and the end date as typed in by the user when the query runs?

Thanks

 

[obli]

Check this thread thread703-739704

 

[randysmid]

Hi,
The real simple answer to this is to add two text boxes to the top of your report, and set the ControlSource to something like this:
=[Forms]![frmRunReport]![txtStartDate]
and the other one:
=[Forms]![frmRunReport]![txtEndDate]

Add the necessary labels to show that the user selected this particular range of dates.

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association