[AccessD] Can't find Query

[Steve Schapel]

Or alternatively that is is Aliased.  You would be able to see that by 
examining the Properties of the source query/table in the query design view. 
Or looking at the SQL you would see something like this...

SELECT SomeField, AnotherField
FROM OneTable INNER JOIN AnotherTable AS SomethingElse ON OneTable.Key = 
SomethingElse.Key

Regards
Steve

-----Original Message----- 
From: McGillivray, Don
Sent: Friday, November 13, 2015 5:28 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Can't find Query

Hi Bob,

Check the SQL behind the query.  It's possible that the "query" showing in 
the design view is really embedded SQL with an alias.

Something like:

SELECT qryFooBar.* FROM (SELECT MyTable.* FROM MyTable WHERE 
MyTable.MyColumn = 'FooBar') as qryFooBar;

In the design view this will appear as a table called "qryFooBar", but that 
query won't exist among your defined queries in the DB container.

Don

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob 
Heygood
Sent: Wednesday, November 11, 2015 9:19 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Can't find Query

Hello to the List,
I am trying to troubleshoot a query that returns an error "Record Deleted".
When viewing in design view, I see the source of the query is another query 
and some tables.
BUT, when looking at the Nav pane, I can't find the source query I see in 
the design view. IOW it seems like it is hidden.
Though when I check if "hidden" objects can be viewed, the option is set to 
view them.
Is it possible that someone deleted it ?
Where is it?

TIA
Bob


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com