SqlStr = "select Count(*) AS mCount from [Enquiry] where [Date] between #" & strStartDate & "# and #" & strEndDate & "# "
如果没有 你可以写 开始时间<=中间时间<=结束时间
啊 写错了 开始时间<=中间时间 and 中间时间<=结束时间
string strStartDate = "2010-05-01"; string strEndDate = "2010-06-01"; string sql = "select * From [表名] where [字段名] Between #" & strStartDate & "# And #" & strEndDate & "#";
fds a f asas d a dsa dsdas das das da s ds d a sd as d a sd a sd s d a d as d as d as d as dd adasd a sd as d as d s d a d as d a das d ad asdad adas d as d a s da d a s d as d as d a s d a d a sda d adas d a sd a sd a sd a s d a sda sdas d a d a sd a s d as d a sd a sdas d
SqlStr = "select Count(*) AS mCount from [Enquiry] where [Date] between #" & strStartDate & "# and #" & strEndDate & "# "
string strEndDate = "2010-06-01";
string sql = "select * From [表名] where [字段名] Between #" & strStartDate & "# And #" & strEndDate & "#";
a
f
asas
d
a
dsa
dsdas
das
das
da
s
ds
d
a
sd
as
d
a
sd
a
sd
s
d
a
d
as
d
as
d
as
d
as
dd
adasd
a
sd
as
d
as
d
s
d
a
d
as
d
a
das
d
ad
asdad
adas
d
as
d
a
s
da
d
a
s
d
as
d
as
d
a
s
d
a
d
a
sda
d
adas
d
a
sd
a
sd
a
sd
a
s
d
a
sda
sdas
d
a
d
a
sd
a
s
d
as
d
a
sd
a
sdas
d