在Access数据表中查询,
数据表名: year_1997
日期项 :StartTime
StartTime 数据在Access中是“日期/时间”数据类型,如1997-1-5 1:05:00在程序中使用的是DateTimePicker1、DateTimePicker2 控件获取用户需要的时间段想达到在数据表year_1997 中查询StartTime 处于 DateTimePicker1和DateTimePicker2的 信息。我的查询语句是:SELECT * FROM Year_1997 WHERE StartTime BETWEEN " + DateTimePicker1.Value + " and " + DateTimePicker1.Value + " "报错,说:语法错误(操作符丢失)在'SELECT * FROM Year_1997 WHERE StartTime BETWEEN " + DateTimePicker1.Value + " and " + DateTimePicker1.Value + " "'中请问要达到我上面的需求,高手们帮我瞧瞧!
数据表名: year_1997
日期项 :StartTime
StartTime 数据在Access中是“日期/时间”数据类型,如1997-1-5 1:05:00在程序中使用的是DateTimePicker1、DateTimePicker2 控件获取用户需要的时间段想达到在数据表year_1997 中查询StartTime 处于 DateTimePicker1和DateTimePicker2的 信息。我的查询语句是:SELECT * FROM Year_1997 WHERE StartTime BETWEEN " + DateTimePicker1.Value + " and " + DateTimePicker1.Value + " "报错,说:语法错误(操作符丢失)在'SELECT * FROM Year_1997 WHERE StartTime BETWEEN " + DateTimePicker1.Value + " and " + DateTimePicker1.Value + " "'中请问要达到我上面的需求,高手们帮我瞧瞧!
如果是在SQL数据库中:
Dim StrSql As String
StrSql = "SELECT * FROM Year_1997 WHERE StartTime BETWEEN '" & DateTimePicker1.Value & "' and '" & DateTimePicker1.Value & "'"如果是在ACCESS数据库中:
Dim StrSql As String
StrSql = "SELECT * FROM Year_1997 WHERE StartTime BETWEEN #" & DateTimePicker1.Value & "# and #" & DateTimePicker1.Value & "#"