Show Results NOT appearing in a Table

[ErikRP]

Okay, first I apologize for the confusing subject line, but I don't know how to better describe my problem, which hopefully is a simple one.

I have two tables, BADCLASS and TERMINATED. BADCLASS shows a list of policies that have a problem. TERMINATED shows a list of policies that have been terminated. Because I don't care about policies with a problem but are terminated, I want to exclude every policy that appears in the TERMINATED table or, put another way, I want to include all the policies in BADCLASS that do not appear in TERMINATED.

Any suggestions? TIA!

 

[Geoff Codd]

Could you not use an unmatched query, show records which do not appear in one table but appear in the other.

Geoff

 

[ErikRP]

Well, I could... If I knew what that was. I'll do a quick search for unmatched queries to see if I can get some background help on how to set them up.

Thanks!

 

[Geoff Codd]

use the unmatched query wizard that will make it alot easier for you

 

[ErikRP]

D'oh!

Thanks Geoff, that was WAY easier than I thought! Thanks for the patience.