Multiple Interrelated Queries

[Guest]

Hello all,

I have several interrelated queries that pull from about 5 tables. On a
weekly basis, I may need to update one of the tables with new information. Is
it necessary to run all queries in order after I update data tables to have
the changes go through everything?

Thanks!

 

[Mr. B]

Hello all,

I have several interrelated queries that pull from about 5 tables. On a
weekly basis, I may need to update one of the tables with new information. Is
it necessary to run all queries in order after I update data tables to have
the changes go through everything?

Thanks!

Joe,

The answer to your question is that it depends of what the changes to
the data will do to the result of the execution of your queries.

You'll just need to evaluate what the quereies are doing and decide
wheather or not all of them need to be run.

If the modifications to your data will affect the results of the
queries, then by all means, they need to be run.

HTH

Mr. B

 

[John W. Vinson]

I have several interrelated queries that pull from about 5 tables.

If they're select queries, you don't need to do *anything* to have them
reflect the changed data. That's what a query IS - a way to view selected,
sorted, arranged data from tables. The data in the query has no independent
existance; it's drawn from the tables at the moment you view the query.

John W. Vinson [MVP]

 

[Guest]

So it's not just a clever nickname... Thanks a ton.