Delete a row

[user name]

i am using this to delete all rows with a certain name

con.Execute "DELETE FROM Tdetails WHERE Name = 'Trade'"

what do you do to delete only one row ?

thanks.

[dglienna]

i am using this to delete all rows with a certain name

con.Execute "DELETE FROM Tdetails WHERE Name = 'Trade'"

what do you do to delete only one row ?

thanks.

WHERE Name = 'Trade'"  and otherData = 'True'

[user name]

thanks for that but the other fields are the same aswell. is there a way of deleting something knowing the row number ?

thanks.