Multiple Reports – Same Query – Underlying Data Changes Frequently

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

We have multiple reports that use data from a single query. This query is
tied to another application’s tables via ODBC.

The data in the other system’s tables is being updated continuously.

Currently we run each Access 2007 report separately which in turns initiates
the underlying query for each report.

This works fine, but we are concerned that we may see different results in
the case where the data in the underlying table is changed between when
Report1 is run and when Report2 is run. It is important that the totals from
the two reports are equal.

Is there a way to force Report2 to use the results of the query that were
built when Report1 was run?

We have started to experiment with sub-reports, by making Report2 a
sub-report of Report1. However, it appears that the underlying query is run
once for the main report and run again for the sub-report.

The second reason that we would like to be able have two reports be able to
pull data from the same execution of one query is for speed. The query in
question runs for 15-20 seconds. We would like to incur this wait time only
once for both reports rather than one time for each report.

Thanks in advance for your help.

Brad
 
I posted this question two times. Sorry about that. I checked my first post
after several hours and it was not showing up, so I posted it a second time.
When I have posted questions in the past, it only took a few minutes for them
to show up. I am not sure what is going on.

Brad
 
Back
Top