unmatched query trouble

[andy49]

Similar idea

One to find which cards John smith does have. From combo and junction table

Then another with the null statement using all cards left joined into first query.



The list will be all cards that John smith doesn't have

[Homegrownandy]

John smith doesn't work here. But thanks! Ill have a crack now shouldn't be too hard.

[Homegrownandy]

Even with the advice. I still had to use the wizard. This defiantly isn't my strong point. Thanks for the help!