请老师们帮帮忙?看看这语句出错在哪?谢谢!
我想查询一段时间内的数据,下面是我的语句,运行出错,请老师们帮忙改改,谢谢!Dim sdate As String
sdate = "投产日期 between #" & DTPicker1.Month & "/" & DTPicker1.Day & "/" & DTPicker1.Year & "# and #" & DTPicker2.Month & "/" & DTPicker2.Day & "/" & DTPicker2.Year & "#"
sql = "select * from 整机表 where" & sdate
Set adors = adocon.Execute(sql)
Adodc1.RecordSource = sql
Adodc1.Refresh
adors.Close
adocon.Close