Help with excluding multiple entries off combining fields

[templeowls]

Very confusing title...sorry. I've attached a simple example DB to try and better explain what I'm looking to do. I've got a query of customers and each customer has two entries each. The last column is a number field and has either a 0 or a 1. I'm trying to come up with an 'if' function where both entries for a customer are excluded if the item fields for both add up to 1 or more.



For instance in my example, baker and smith's two entries would remain because they equal zero. Whereas the others would be excluded. Super weird question I know.

I appreciate any help.

Thanks

[Gicu]

Something like this maybe (using a subquery) - you could also use a dCount.

Cheers,
Vlad

[templeowls]

Thank you!!!