Query to return records NOT found (Access XP)

Topic

New Reply

My clients pay me a fee once every year. I store client

Reply | Quote

Replies

Hi Ian
There was a wizard in Access 97 that found unmatched data …
Your solution will probably involve two key elements

a left join
&
a condition where somefieldName is Null

e.g
SELECT distinctrow tbl_x.fieldName FROM
tbl_x LEFT JOIN tbl_y ON
tbl_x.fieldName = tbl_y.fieldName
WHERE tbl_y.fieldName IS NULL;

It is easier with teh Wizard

Cheers
Geof

Reply | Quote

Geof

Thanks a lot. It is easy with the wizard!!

Ian

Reply | Quote