dim strDate as string
dim datenow as date
datenow = date
strdate="#" & datenow & "#"
sqlstr = "select * from 表 where #表.日期# < " + "'" + strdate + "'"
dim datenow as date
datenow = date
strdate="#" & datenow & "#"
sqlstr = "select * from 表 where #表.日期# < " + "'" + strdate + "'"
ACCESS 的日期用 # 分隔SQL2000: sqlstr = "select * from 表 where 表.日期 < " & "'" & datenow & "'"
ACCESS: sqlstr = "select * from 表 where 表.日期 < " & "#" & datenow & "#"