How to write code to delete record based on field value?

[ssanfu]

That happens when you create a query in the query designer, then switch to SQL view. Usually doesn't hurt anything if you want to edit the SQL and remove the "extra parentheses".

SELECT TableGroup.GroupName AS EmptyGroupFROM TableGroup
GROUP BY TableGroup.GroupName
HAVING Sum([Administrator]) = 0;

[accesstos]

Does below code missing dbs.Execute "qryEmptyGroups" for the first line?

No, it's not needed in this code. qryEmptyGroups is part (subquery) of AppendQuery and DeleteQuery.

P.S.
I see that the EmptyGroupFROM is one word. You have to separate them with a space: EmptyGroup FROM

[VAer]

Thanks so much!