select * from JLB where 姓名='张三' and 购物时间>DTPICKER1 and 购物时间<DTPICKER2
select * from JLB where [用户姓名]='张三' and 购物时间 between DTPICKER1 and DTPICKER2
select * from JLB where 用户姓名 = '张三' and 购物时间 between 'DTPICER' and 'DTPICER1'
怎么别人跟你们写的不一样呢 strsql=" SELECT * FROM JLB WHERE 用户姓名='张三' AND 购物时间 BETWEEN '"& FORMAT(dtpicker1.value,"YYYY-MM-DD") & " 00:00:00' AND '"& FORMAT(dtpicker2.value,"YYYY-MM-DD") & " 23:59:59'"
你这里多算了一天时间, 那你改这样也可以,而且简单多了select * from JLB where [用户姓名]='张三' and 购物时间 between DTPICKER1 and dateadd(dd,1,DTPICKER2)
时间点儿的是从0点到24点。如果是年月日 直接就 between and
select * from JLB where 用户姓名 = '张三' and 购物时间 between 'DTPICER' and 'DTPICER1'
select 用户姓名,购物时间, 物品名称,单价,数量,金额 from JLB where 购物时间 between DTPICKER1 and DTPICKER2
from JLB
where [用户姓名]='张三' and 购物时间 between DTPICKER1 and DTPICKER2
select * from JLB where 用户姓名 = '张三' and 购物时间 between 'DTPICER' and 'DTPICER1'
strsql=" SELECT * FROM JLB WHERE 用户姓名='张三' AND 购物时间 BETWEEN '"& FORMAT(dtpicker1.value,"YYYY-MM-DD") & " 00:00:00' AND '"& FORMAT(dtpicker2.value,"YYYY-MM-DD") & " 23:59:59'"
from JLB
where [用户姓名]='张三' and 购物时间
between DTPICKER1 and dateadd(dd,1,DTPICKER2)
from JLB
where 购物时间 between DTPICKER1 and DTPICKER2