How to get a list of records excluded from a Query

[Agcriado]

Hi, any help will be very welcome.

I have two tables, and I link them(make a relationship) by field, then I create a Query where I choose the link field and all the others of one of the tables. This gives me the a list of records that are linked by the linked field.

Now, How can I get a list of the ones that are not included in that query?

I guess that the solution will be very easy, but I don't know it. So please help me!!

Thanks and regards,
Bigger from London

 

[FoFa]

If in QBE (query designer) link the field, the click on the line linking them, choose a join other than inner (both fields equal).
Then in your criteria, select where the joined filed from the table IS NULL.
Example:
Currently
SELECT yada, yada
FROM MyTable1
INNER JOIN MyTable2 on MyTable1.MyKey = MyTable2.MyKey

New One.
SELECT Yada, Yada
FROM MyTable2
LEFT JOIN MyTable2 on Mytable2.MyKey = MyTable1.MyKey
WHERE MyTable1.MyKey IS NULL

Basically

 

[mavver]

can you not just use the "Find Unmatched Query" wizard?