Query Dynamic Reference

[PSULionRP]

I understand dynamic references to queries from other queries. Like
referencing a column from another query which in turn will run that query.
However, when I drill down to that dynamic query, there is yet another
dynamic reference that I cannot seem to find anywhere within this Microsoft
Access Database....it's not a Table, it's not a named query...what is it
possibly referencing and is there any way that I can find the reference
within the entire Access Database???

I appreciate your review in advance and am hopeful for a response. I hope my
question is straight forward enough.

Thanks!

PSULionRP

 

[John Spencer]

It could be a sub-query in the FROM clause of the main query which will show
up in design view as a table (or query).

It could be a hidden table or query.

One thing that would help is to post the SQL of the query that contains the
"dynamic reference" that you cannot locate.

Open the query in design view
Select View: SQL
Copy and paste the SQL statement

If you post back, tell us the NAME of the "dynamic reference".
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County