Hi All, wondering if someone could help me resolve my delete query problem?
As a select query, this works as I need/want it to
Query Results, showing me I have a record with a Group but no UserID entered and a record with the same Group and an ID entered.
I want to delete records where the UserID Field is empty, but ONLY if the group has a complete record in the table already.
When I convert to a delete query
I get the following error/ I want to delete the record from the very table I ran my query against which is identified in the qury, but it doesn't seem to know that.