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.
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.