以文本方式查看主题

-  Foxtable(狐表)  (http://www.foxtable.com/bbs/index.asp)
--  专家坐堂  (http://www.foxtable.com/bbs/list.asp?boardid=2)
----  请问下列过滤字符串表达式错在哪里?为什么老报错“编译错误:应为语句结束”?  (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=110772)

--  作者:asdf44168
--  发布时间:2017/12/9 9:54:00
--  请问下列过滤字符串表达式错在哪里?为什么老报错“编译错误:应为语句结束”?
flt = "(" & flt1 & " And " flt2 & ") Or (" & flt1 &  " And " & flt3 & ") Or (" & flt2 &  " And " & flt3 & ")"

其中flt1~flt3格式类似,如:
flt1 = "([num1] = " & nbox4(1).value & " Or [num2] = " & nbox4(1).value & " Or [num3] = " & nbox4(1).value & " Or [num4] = " & nbox4(1).value & " Or [num5] = " & nbox4(1).value & " Or  [num6] = " & nbox4(1).value & ")"

[此贴子已经被作者于2017/12/9 9:57:40编辑过]