Background :
I have a query thatlooks at all the records in “EventsLog” table. I have a field [UserID] in thattable that shows who the Event is assigned too. When I delete a User it leavestheir assigned events in “EventsLog” but the [UserID] is blank.
I want to make aquery that finds any Event with a blank UserID so I can delete them.
The problem I think is something to do with blank vs null.
SUPER bonus - is there a way to make a button that deletes all "Events" with a Null/Blank [UserID]?
Setup: