Hi Vipul,Thank you for your response. I am actually looking to exclude a
number of households based on a field in another table linked to
recipient. I apologize I didn't provide all requirements initially. A
little more detail:Select all recipients that are type = prospect.
Exclude any prospects that have the same household ID as recipients that
have a certain type of contract. Contract is a one-to-one linked table
to recipients. The primary key is ID. Does that clarify what i am trying
to do? I...