help deleting row

[marniel647]

guys help me with this

i put the code into button

 Dim connect As New OleDbConnection(conString)
            connect.Open()

            Dim dsql As String
           

            dsql = "DELETE FROM InventoryItem"
            dsql = dsql & "WHERE TransactionDate = '" & TransactionDateText.Text & "'AND "
            dsql = dsql & " ItemName = '" & ItemNameText.Text & "' AND Quantity = '" & QuantityText.Text & "' AND"
            dsql = dsql & " Price = '" & PriceText.Text & "' AND Cost = '" & CostText.Text & "' AND"
            dsql = dsql & " Type = '" & InTextbox.Text & "'"

but when i click the button it gives me an error

the error is "Syntax Error in FROM clause"

help me guys sorry new in vs 2008