storing query results in tables

  • 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
 
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.
 
Back
Top