技术求教,以下查询的代码语法有误?
' rs11.Open "Select * from 数据 Where 设备编号='" & Combo1.Text & "' And 确认状态='" & Combo4.Text & "'and 提交日期 between '" & DTPicker1.Value & "' and '" & DTPicker2.Value & "' ", conn11, 3, 2
这句代码中,语法错误,请大神帮忙指出?

' rs11.Open "Select * from 数据 Where 设备编号='" & Combo1.Text & "' And 确认状态='" & Combo4.Text & "'and 提交日期 between '" & DTPicker1.Value & "' and '" & DTPicker2.Value & "' ", conn11, 3, 2