SQL to detete multiple records.

[EddyLLC]

There may be multiple line in the table that match the sql statement below. Can this code be changed to delete them all instead only one of do I have to open up a record set of the table and put some kind of Do/Loop in ?

SQLStmnt = "delete FROM tbl1 WHERE [File] = '" & strRef & _
"' AND Inv = '" & strInv & "' AND Field2 = '" & strField2 & _
"' AND LineNum = " & strLine
CurrentProject.Connection.Execute SQLStmnt

 

[PHV]

ALL the rows matching the WHERE clause should be deleted.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lamarw]

Since the SQL statement is filled with AND clauses when you say that there may be multiple lines that match theSQL statement do you mean matching what you ahve typed as the SQL statement? If so that will take care of all the row's in the table.

Lamar