Hi
I have 4 reports that are based on parameter queries. Each report shows a list of business activities and related info over a date range that is set as the parameter.
The 4 reports together form a single report that must be circulated to the company. I would like to save time by making a macro that prints each copy of the report, but without asking for what is effectively the same start date 4 times in a row.
Is this possible?
If not, the other solution is to change the queries that the reports are based on. The start date for each report will typically be the 1st of the month for the month before the report is run (eg if I ran the report today, the strat date I would give the query is 1st June 2002) Can I set a date like this in SQL using GETDATE?
Any help would be greatly appreciated!
G
I have 4 reports that are based on parameter queries. Each report shows a list of business activities and related info over a date range that is set as the parameter.
The 4 reports together form a single report that must be circulated to the company. I would like to save time by making a macro that prints each copy of the report, but without asking for what is effectively the same start date 4 times in a row.
Is this possible?
If not, the other solution is to change the queries that the reports are based on. The start date for each report will typically be the 1st of the month for the month before the report is run (eg if I ran the report today, the strat date I would give the query is 1st June 2002) Can I set a date like this in SQL using GETDATE?
Any help would be greatly appreciated!
G
