storing query results

  • Thread starter Thread starter tim h
  • Start date Start date
T

tim h

I have a series of tables that are used to create complex
query calculations. Once these calculations have been
performed, I want the final query results to be stored
back in these original tables.

The reason for this is because if I run the "Accounts"
query, I don't want all of these calculations to be
performed again on a large scale because it takes too
long. I simply want previously calculated data to be
recalled.

Any suggestions?
Thankyou. Tim .
 
Write the results to a temp table that has these fields:
- a field for each result (or the one result) of the calculation;
- a field that holds the ID value that this calculation matches.

After verifying the results in the temp table, you can then execute an
UPDATE query statement to write the results back to the main table. If you
are not sure how to do that:
1. Create a query into the temp table and the real table.

2. Make sure the join is correct (on the ID fields).

3. Change it to an Update query (Query menu).

4. Drag the field(s) to be updated into the grid.

5. In the Update row, enter the field from the matching table, e.g.:
[MyTempTable].[MyResult]

6. Run the query.
 
Back
Top