这样用说是日期语法错误 where tdate <= #DTP_ByDatesTo.Value# and tdate >= #DTP_ByDatesFrom.Value#"
where tdate <= '" & Format(DTP_ByDatesTo.Value, "yyyy-mm-dd H:mm:ss") & "' and tdate >='" & Format(DTP_ByDatesFrom.Value, "yyyy-mm-dd H:mm:ss") & "' 这样提示标准表达式中的类型不匹配
to qiaol_mail(阿Q) 这样用写完语句#' and tdate这里提示缺少语句结束 where tdate <= '#" &DTP_ByDatesTo.Value&"#' and tdate >='#" &DTP_ByDatesFrom.Value&"#' 这个也一样 where tdate <= #" &DTP_ByDatesTo.Value&"# and tdate >=#" &DTP_ByDatesFrom.Value&"#
tdate <= '"&#DTP_ByDatesTo.Value#&"' and tdate >='" &#DTP_ByDatesFrom.Value#&"' 这样在写完语句后在第一个#处提示缺少表达式
在"&"和变量中间加空格,详细的语法我也没办法手把手教你了
where tdate <= #" &DTP_ByDatesTo.Value&"# and tdate >=#" &DTP_ByDatesFrom.Value&"# 提示日期语法错误
where tdate <= #'" &DTP_ByDatesTo.Value&"'# and tdate >=#'" &DTP_ByDatesFrom.Value&"'# 提示日期语法错误
where tdate <= #DTP_ByDatesTo.Value# and tdate >= #DTP_ByDatesFrom.Value#"
这样提示标准表达式中的类型不匹配
这样用写完语句#' and tdate这里提示缺少语句结束
where tdate <= '#" &DTP_ByDatesTo.Value&"#' and tdate >='#" &DTP_ByDatesFrom.Value&"#'
这个也一样
where tdate <= #" &DTP_ByDatesTo.Value&"# and tdate >=#" &DTP_ByDatesFrom.Value&"#
这样在写完语句后在第一个#处提示缺少表达式
提示日期语法错误
提示日期语法错误
加了空格