Adding a query/Report Date Range on a report to be viewed

[cosblade]

I ahve Several Reports that run off of a Date range. When the report is opened it asks for these date ranges. How do I include these date ranges on the Report itself?

 

[dhookom]

What did you do to get your report to "ask(s) for these date ranges"? IMHO, you shouldn't use parameter prompt queries. They are too limiting and not very functional.

You should always use controls on forms to filter forms and reports. You can then reference these control values in your report with a text box and control source like:
=Forms!frmDates!txtStartDate


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]