求救 VB查询中, between……and 的用法

---

txtsql = "select * from kaoqinbiao where (考勤时间 between #" & DTPicker1.Value & "轿陵坦# and #" & DTPicker2.Value & "#) and 部闭桐门='汪让" & Trim(Combo1(0).Text) & "' and 姓名='" & Trim(Combo1 (1).Text) & "'"

---