beDate = "日期>=#" & dtBegin & "# and 日期<=#" & dtEnd & "#"
rsRK.Open "select * from Source_Buy where " & beDate & " ORDER BY 日期 DESC", cn, adOpenDynamic, adLockReadOnly出错信息是:
实时错误:-2147217900(80040e14)
第一行:'#'附近有语法错误.
rsRK.Open "select * from Source_Buy where " & beDate & " ORDER BY 日期 DESC", cn, adOpenDynamic, adLockReadOnly出错信息是:
实时错误:-2147217900(80040e14)
第一行:'#'附近有语法错误.
beDate = "日期>='" & dtBegin & "' and 日期<='" & dtEnd & "'"
SQL查时间是用字符串查找的方式