Only show records that do not appear in another query

[mbamber]

Hi all,

Currently I have a query, QRY_Test which contains a load of records under the fields "Gift_ID" and "Person_ID". I have another query, QRY_PersonList in which I would like to show all of the "Person_ID"s except the ones returned by QRY_Test.

I hope this is a really simple fix but I just cant seem to work it out! If you need more information, just let me know.

TIA

 

[pbaldy]

Try the unmatched query wizard.

 

[mbamber]

Thank you! Worked a treat.

 

[pbaldy]

No problemo!