Access数据库。BeginTime = DTPicker3.Value
EndTime = DTPicker2.Value
strSQL = "SELECT 订单表.订单编号,订单表.产品编号,订单表.产品数量,订单表.交货日期 FROM 订单表,产品表 WHERE 产品表.产品编号=订单表.产品编号 AND 产品表.产品厚度='" & Hou & "' AND 发货日期>='" & BeginTime & "' AND 发货日期<= '" & EndTime & "'"报错:类型不匹配。
EndTime = DTPicker2.Value
strSQL = "SELECT 订单表.订单编号,订单表.产品编号,订单表.产品数量,订单表.交货日期 FROM 订单表,产品表 WHERE 产品表.产品编号=订单表.产品编号 AND 产品表.产品厚度='" & Hou & "' AND 发货日期>='" & BeginTime & "' AND 发货日期<= '" & EndTime & "'"报错:类型不匹配。
AND 发货日期>=#" & BeginTime & "# AND 发货日期 <= #" & EndTime & "#"
数据库为SQL:
AND 发货日期>='" & BeginTime & "' AND 发货日期 <= '" & EndTime & "'"