Filter out Matching records

[wtrimble]

I have a table "tblengopp" that has a field "Oppid" which is the primary key for that table. I have another table tblprojectinfo that also has a field "Oppid" that uses the Oppid's from "tblengopp"

I need to create a query that shows all of the "Oppid"s in tblengopp that don't show up in tblprojectinfo.

I can't think of how to do it.

Please help. Thanks.

 

[Kryst51]

How about using the unmatched query wizard? I am not possible that is what you need though.