Query Critera - IsNull - Not working

[tsgtnissen]

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:

[Bob Fitz]

If you change the relationship between the two tables so that it enforces referential integrity, related records will be deleted as the same time.

That said, it might be better NOT to delete records but mark those as no longer "Required".

[tsgtnissen]

That worked!

[Bob Fitz]

That worked!

Ah! Good. That what we like to hear. Another satisfied customer