Display parameter results in report (1 Viewer)

[trstorer]

I have a report that prints based on the results of 5 queries. The third query prompts w/ a parameter for the first day and the last day of the report period.

Is there a way to get these two dates to automatically print in the page header of the report?

FYI -
Query 1 - Pulls all info where date is null, i.e. open cases.
Query 2 - Finds "max" date for each case in Query 1
Query 3 - Finds all action during previous month
Query 4 - Union query with Query 2 & 3.
Query 5 - Join query to gather all info necessary for report based on the results of Query 4 (Union)

Thanks for your help.

 

[bill crumpton]

Sure is.....just create two unbound fields in your report header ...one for beginning date and one for ending date. then in the control source of both field put in the exact parameter criteria that you put in the query. For example, in the criteria of the query you have >=[Beginning Date] and <=[Ending Date], then in the begininng date field's control box enter "[Beginning Date]" and in the control source of the ending field enter "[Ending Date]". This should help you.