subquery

G

geebee

hi,

i created a query (qry1) in access, and saved it. then i used it within
another saved query (qry2) to link it to the table. do i need to run qry1 to
refresh it before running qry2, or is qry1 automatically run/refreshed when i
run qry2?

thanks in advance,
geebee
 
J

John Spencer

Your qry1 will automatically run when you use it in qry2.

I like to think of it this way.
Queries are simply a set of instructions to return records. As such the
query itself never contains any data. It only returns and displays the
data that corresponds with the set of instructions that is the query.



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top