Award search

Is there a way to run a report for active members who have not received a specific award?

Yes I can run a report to see who has received the award - then I have to go through and manually compare the active list with the award list.

Or I can run a who hasn't received the award search and have every single member who was ever with the program - including the ones who have moved away or died - appear on the list.

I just want active members who have not received a specific award!