Capturing query criteria used in a report

[hallm]

I'm using criteria in a query to capture a data span.

Between [Type the beginning date:] And [Type the ending date:]

I'm using this query for the data on my report, so that when you run the report it prompts you for the dates then brings up the report.

How can I capture those dates for use on my report?

Example This report contains data from begdate to enddate.

Marion

 

[dhookom]

Add a text box with a control source of:
="This report contains data from " & [Type the beginning date:] & " to " & [Type the ending date:]


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]
[blue]Ask me about my grandson, get a grand answer.[/blue]