I have a main report that is basically acting as a template. It contains no data itself but uses the Main query as the Record Source and Prompts the user with a Start and End Date request. Within the Main report are 4 Sub reports that are all using different queries built off the main query and other queries to gather data and complete the request. Everything is working fine with the data and reports except I have to enter the Start Date and End Date 5 times...once for each report.
I set the Link Master & Link Child Fields to the [Trans Date] field on all reports which is the field I'm entering criteria on hoping that would pass through the Date Criteria entered but that didn't work.
Any help would be greatly appreciated.
Thank you
Tom
I set the Link Master & Link Child Fields to the [Trans Date] field on all reports which is the field I'm entering criteria on hoping that would pass through the Date Criteria entered but that didn't work.
Any help would be greatly appreciated.
Thank you
Tom