I am trying to find customer sites that have not had a battery replaced.

I added NOT ({IN_Part.Description} like "*Battery*") to the Select group.

The problem I am having is that the sites which had a battery replaced are still showing up on the  report.  However the detail does not show the battery record.

So if I ran a report without the NOT and any selection criteria for battery then all sites will be listed and the records for battery would be listed in the detail for sites that had a battery replaced. 

Or I run the report with  {IN_Part.Description} like "*Battery* then only site with a battery replaced show up.

But the NOT does not just only show sites where a battery was not replaced.

What am I missing?