How can I change this code to make the "Occupied" field null? This is just a
small part of a larger peice of code but this is whats causing my issue.

DoCmd.RunSQL "UPDATE [On Hold Records Table 2] SET [On Hold Records Table
2].Occupied is null" & _
"WHERE ((([On Hold Records Table 2].Identifier)='" & Identifier & "'));"