We've added a checkbox to our contacts and need a search to find any customer who has no contacts with the checkbox checked. The search is not eliminating customers who have contacts with the checkbox checked if there is more than one contact. I tried using a COUNT summary on the checkbox, but it's not working. Any advice?

are you doing the

COUNT

in Results->Columns, or in Criteria->Summary tab?

Tried both. Neither worked.

hmm..this is how i wouldve done it:

tested real quickly, and this seems to work for me.

None of these are working, unfortunately. The one example company I'm looking at has two contacts. One is checked, the other isn't. Because there is one contact that has it checked, it isn't being eliminated.

are you summarizing your results?

Okay, that seem to have worked! I will do some spot checking to ensure.

Right on! Summary criteria require summarized results in order to work.

Thank you!