It's probably easier to go over my problem than try to describe it...

Simple two table query. A person table and an emailaddress table. I'm trying to select all people who are flagged as active ( based on field in the person table). The active people may have multiple email addresses. Possible types are business or personal.

I want the report to only show the business address. But when I run into a record in the person file with out a record in email table with type=business that person doesn't show on the report if I select email_type=BUS

But if I don't put that in I get multiple report lines with both the personal and business email addresses.

Thanks