Show records that aren't matched in a 2nd table

[NeilPattison]

Hi everyone

I have two tables that are matched by the primary key of first table (by matched I mean parent/child on a form).

I want to be able to write a query that shows the records in the first table (tblDetails) that don't have a match in the second table (tblfigures).

I have attached an example database to show what I mean.

In the examples case the records that should be returned are 2, 4 and 6


Any help on this would be greatly appreciated.

 

[PHV]

Did you try to follow the unmatching query wizard ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[NeilPattison]

Thanks forgot about that wizard.

Works great