2011-06-20至2011-06-20就不能用等于了 得用 sql="select * from CHECKINOUT where userid="&request.querystring("zhou_leijie_jie") & " and checktime between 2011-06-20 and 2011-06-30"
ACCESS:
checktime between '#2011-06-20#' and '#2011-06-30#'
SQL:
checktime between '2011-06-20' and '2011-06-30'
checktime> '#2011-06-20#' and checktime< '#2011-06-30#'
or
checktime between '#2011-06-20#' and '#2011-06-30#'
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024