Question

ACCESS用VBA中统计两个日期之间的数据查询如何写,

select * from 表1 where BETWEEN ME.[开始日期] and ME.[结束日期

Answer 1

在日期的前后,加上“#”号,如下所示:
"select * from 表1 where BETWEEN #" & ME.[开始日期] & "# and #" & ME.[结束日期 & "#"

Answer 2

用两个datediff