sql delete syntax

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone please help me with my syntax.

strSQL = "DELETE * FROM AllNewParts WHERE [Model] = Me.Model & [Part] =
Me.New Part & [NHL] = Me.New Part NHL

I am trying to delete records from the AllNewParts table and I have a hard
time with this syntax. All 3 fields are text. Thanks for your help. Alex
 
strSQL = "DELETE * FROM AllNewParts WHERE [Model] = '" & Me.Model & "'
AND[Part] = '" & Me.[New Part] & "' AND [NHL] = '" & Me.[New Part NHL] & "'"
 
Back
Top