storing query results in tables

[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

 

[Gina]

One suggestion: Make an Append Query and have it write to a field in the
query but make sure you include a don't overwrite clause in your code. All
of this is assuming you are proccessing the query via a buttion.