HELP! Lost Access Query

[mchong71]

So I have a very strange problem here. I am not the original developer of the database that I'm working on but am debugging certain problems. During this process I am trying to trace back certain fields.

Here's the problem:

I'm in the query design of "query1" which uses "query2". When I go to find query2 in the navigation pane its not there. I've made sure to display all hidden objects and yet it still does not appear. I know that if you delete a query it also deletes it from any query that is using it.

Sooo...my question is can you dynamically create a query within another query so that it doesnt show up in the nav. pane, and if not how is this situation possible?

 

[mdmilner]

They're called subqueries.

You can look at something like this example for some information:
http://beginner-sql-tutorial.com/sql-subquery.htm

Something I'd suggest doing is changing the view to SQL view and then looking at the statement there carefully. Queries can actually reference external objects (outside your current database) but they always require an explict path to the database and then it explictly mentions the precise query.