help

[rjhe22]

i have 2 tables..
what i want to do is run a query that shows whats in 1 table but not the other how can this be done. i have tried a few different things and cant get it

 

[Kiwiman]

Howzit

You want to use a Left Join (Join Properties - option 2) and use the IS Null criteria on the right hand table field to return all records for the left hand table not in the right hand table. For example - the below returns all rounds in my header table (tblRoundHdr) that I do not have any round info in my detail table (tblRoundDtl):

SELECT tblRoundHdr.RoundID, tblRoundDtl.RoundID
FROM tblRoundHdr LEFT JOIN tblRoundDtl ON tblRoundHdr.RoundID = tblRoundDtl.RoundID
WHERE (((tblRoundDtl.RoundID) Is Null));

 

[rjhe22]

will try that thanks

 

[vbaInet]

Kiwiman's good suggestion will work if all you're doing is comparing against the unique fields. So you need to tell us if the comparison is based on an entire row or just one field.

If you're happy with the results as you have it, ignore me