Displaying Select Criteria

[krispi]

Mornin' all...

My report is based on a query. In the query, I have added criteria to prompt the user to enter start date and end date, thus selecting only records created between these two dates.

Is there any way I can automatically display the two dates entered by the user in the header of my report?

This is my second day working with reports, so please be gentle with me!

 

[CosmoKramer]

Sure,

Add a text box to your report and put the prompts exactly as they appear in the query as its control source, plus a little optional text. So, if your prompts are [Enter Beginning date] and [Enter Ending date], then:

="For the dates " & [Enter Beginning date] & " to " & [Enter Ending date]

 

[krispi]

Thanks a million - that's great.

Chris