How to check if the record exists in one table but not in another

**accessLearn** · 08-09-2015, 09:59 AM

I have a table tblA with emplid, joindt and jointm and department.
I have another table TblB with emplid, joindt and jointm and department.

tblA has 4 rows with same emplid and differnt join date+jointm and tblB has 3 rows with same info.
How can I write a query in access to check which row is missing from from TblB
I tried below statement but not getting anything
select * from tblA where notexists (select joindate+jointm from tblB where tblA.emplid=tblB.emplid )

Thanks,

Blyzzard

**pbaldy** · 08-09-2015, 10:03 AM

Try the unmatched query wizard.

How to check if the record exists in one table but not in another

Thread Tools

How to check if the record exists in one table but not in another

Similar Threads

DLookup: Check if a record exists before adding to a different table

Using a textbox control to check to see if a record exists in a table

Check if record exists, Check Number

Using Access VBA to check if the record exists in the table

Check to see if record id exists in joined table

Posting Permissions