var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query works on tables but not other queries
Trying to find a list of all records in tableB that ARE NOT in table A. Here's the code I use:
SELECT tblB.username, tblB.entity
WHERE NOT EXISTS (select tblA.username, tblA.entity from tblA where tblA.username = tblB.username and tblA.entity = tblB.entity);
That code works great as long as the data sources are tables. If I change it to qryA and qryB, it will lock up Access. qryA and qryB have the EXACT same structure and design as tblA and tblB.
The easiest approach would be to use the 'find unmatched' wizard as part of the query wizards.
I have just tried running a couple of Difference Queries where query objects were used in place of table objects.
Originally Posted by msellery
They appeared to work just fine for me.
Can you reproduce your DDL and query object SQL and some sample data here?