I have built 12 queries that obtain data from the same 2 tables but for 12 different reports. I have created 12 separate reports as well. I want to run all 12 queries/reports at once. I have set up a filter in which I enter 'from' and 'to' dates, but I have to do this for each query/report. I want to build a macro that will run all 12 reports at once, and all I'll have to do is manually enter the dates one time at the beginning of the macro. I can not get the date filter at the beginning of the macro to operate successfully - keep getting error message. Where can I get good resource data that will help me with this macro? The Microsoft online help doesn't cut it.