O
owp^3
I run a monthly report that has 3 subreports. The process works like this:
An append query is run to load Production Data into an empty
staging/reporting table so we can manually supress/edit lengthy memos.
After the report is in its publishable form we append the data from the
staging table into a similarly structured report history table with a date
stamp.
Thus we have 3 different sources of data and a query for each with the same
results structure. I want the user to be able to populate the report by
selecting from a list of the historical report dates and current production
data and the staging data.
The list would look like this:
10/18/2007
11/15/2007
12/19/2007
Draft
Current
What will be the easiest/best way to do this?
Should the selection launch the report or should the report load prompt the
user?
Thanks,
owp^3
An append query is run to load Production Data into an empty
staging/reporting table so we can manually supress/edit lengthy memos.
After the report is in its publishable form we append the data from the
staging table into a similarly structured report history table with a date
stamp.
Thus we have 3 different sources of data and a query for each with the same
results structure. I want the user to be able to populate the report by
selecting from a list of the historical report dates and current production
data and the staging data.
The list would look like this:
10/18/2007
11/15/2007
12/19/2007
Draft
Current
What will be the easiest/best way to do this?
Should the selection launch the report or should the report load prompt the
user?
Thanks,
owp^3