Hi All,
I have 8 queries all with a date field. I have one report that shows the fields from all of these queries. I'm opening the report from a print dialog box that has a date range - so I'm opening the report with a docmd.openreport line. It's easy enough to do with just one query, sending the date range - but how do I do it with multiple queries? I mean, how do I send the 1 date range to all 8 queries in one docmd?
Regards,
Mark
I have 8 queries all with a date field. I have one report that shows the fields from all of these queries. I'm opening the report from a print dialog box that has a date range - so I'm opening the report with a docmd.openreport line. It's easy enough to do with just one query, sending the date range - but how do I do it with multiple queries? I mean, how do I send the 1 date range to all 8 queries in one docmd?
Regards,
Mark