Query based on a query

D

Donna

When I run Query2 that is based on Query1, does Query2 actually run Query 1,
or does it grab the currently saved data. Both queries are updated according
to Today's date.
 
A

Albert D.Kallal

I am not sure I understand the question.

Query1 will go to the existing tables, and pull out data. This data is then
passed on to query2.

Both queries are updated according
to Today's date.
Click to expand...

Updateing a query has absoltiong nothing to do with the data in the tables.
You can change queries all day long, but if you don't run the query, then
they don't touch the actual data. When the query runs, it goes to the actual
tables..and pulls out the data.

So, the query can be anything you want, but they ALWAYS GO to the actual
tables to retrieve data. They are simply a "view" to the existing live data
in the tables. In fact, it is interesting to note that when you use sql
server, they call saved queryies "views". I kind of wish they did the same
thing in ms-access.

So, if you got 5 queries, the first query will go to the actual table data,
ad then pass the data to the next query.

It is possible I am miss-understanding your question, so do feel free to
expand if I missed what you are asking.
 
D

Donna

Let me expand:

Query 2 was created based on Query 1. If I open(run) Query 2 and its only
based on Query 1, does Query 1 then run and grab the actual data from the
table?

Is it automatic that when Query 2 is run, it runs Query 1 which show the
data from the table?

I hope that is clearer.
 
V

Van T. Dinh

Yes.

There is *no* data stored in the design of the Queries.

Actually, I think Access may be a bit smarter than simply run Q1 and then
use the result as the Source for Q2. My feeling (I haven't seen any doc to
confirm this) is that Access actually combines the SQLs and run the combined
SQL rather than 2 SQLs sequentially.
 
Top