[RESOLVED] Select with multiple conditions

[MartinLiss]

I have some code where this works fine

With rs
    .Open "SELECT * FROM Requests where RequestType = '" & Cells(Target.Row, 1) & "'", cn, adOpenKeyset, adLockOptimistic, adCmdText
    
    .Fields("Status").Value = Cells(Target.Row, 4).Value
    .Fields("Notes").Value = Cells(Target.Row, 6).Value
    .Update
End With

I'm trying to add a second condition and the syntax is wrong. What's my mistake?

.Open "SELECT * FROM Requests where RequestType = '" & Cells(Target.Row, 1) & "' AND DateCreated = '" & cells(target.Row, 2) & "'", cn, adOpenKeyset, adLockOptimistic, adCmdText