Do queries re-execute in the following situations

[Guest]

When I select a query from the page where my queries are listed as objects,
and export it, does the query run again before exporting or does it export
the results from the last time the query was run?

When I run a query (call it query 2) that queries another query (call it
query 1), does query 1 re-execute first as part of the execution of query 2?

When I export a query (call it query 2) that queries another query (call it
query 1):
- does query 1 re-execute before exporting?
- does query 2 re-execute before exporting?
- or does Access simpy export the results from the last time query 2 was run?

Thanks,
Pat

 

[Jeff Boyce]

Pat

What happens when you test this?

Queries in Access are a way to dynamically retrieve data. This means that
whenever you run one, what runs is the instructions on how to retrieve data,
and not a collection of data left over from the last time.

When you EXPORT a query, you are telling Access to run the query
(instructions) and send the results to ... (whereever you are exporting to).

When query2 calls query1, it is dynamic, running the instructions, not using
a fixed data set (see a pattern emerging here?<g>).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Marshall Barton]

When I select a query from the page where my queries are listed as objects,
and export it, does the query run again before exporting or does it export
the results from the last time the query was run?

When I run a query (call it query 2) that queries another query (call it
query 1), does query 1 re-execute first as part of the execution of query 2?

When I export a query (call it query 2) that queries another query (call it
query 1):
- does query 1 re-execute before exporting?
- does query 2 re-execute before exporting?
- or does Access simpy export the results from the last time query 2 was run?

Both queries will be executed at the time of the export.

 

[Guest]

A query has no way of knowing what it retrieved the last time it ran.
Queries do not contain any data. Neither do forms or reports. The only
objects that store data are tables. Queries are nothing more than a set of
instructions the tell the database engine what they want done with data.