以文本方式查看主题

-  易表在线答疑  (http://egrid2000.com/dvbbs/index.asp)
--  用户社区  (http://egrid2000.com/dvbbs/list.asp?boardid=2)
----  [求助]一个公式的修改  (http://egrid2000.com/dvbbs/dispbbs.asp?boardid=2&id=20211)

--  作者:swg-1954
--  发布时间:2010/11/12 12:23:00
--  [求助]一个公式的修改
If([%开始号%] <= 0 Or [%结束号%] <= 0 Or [%开始号%] > [%结束号%],MsgBox("正确选择号码!",0),SetLabel("  ","稍等---!") And AddCol(GridName,"p",3, False ) And EvalFor(GridName,"p","[MR_SECT_NO] >= [%开始号%] And [MR_SECT_NO] <= [%结束号%] And [READ_TYPE]=""121"" And [THIS_READ]-[LAST_NUM] >= 20,[T_FACTOR] <= 30") And FilterFor(,"p","=",-1) And Report(GridName,"09",1,Rows,0) And ShowAllRows() And DeleteCol(GridName,"p") And EvalFor(GridName,"打印份数","[MR_SECT_NO] >= [%开始号%] And [MR_SECT_NO] <= [%结束号%] And [READ_TYPE]=""121"" And [THIS_READ]-[LAST_NUM] >= 20,[T_FACTOR] <= 30","打印份数","=",0) And SetLabel("  ","") And SetLabel(" ",Text(CountFor(GridName,"打印份数","=",-1))))
上面公式增加了[T_FACTOR] <= 30就不运行了,错在那儿,请教了。
--  作者:wjq1072
--  发布时间:2010/11/12 13:45:00
--  
And [T_FACTOR] <= 30
用And 连接。
--  作者:swg-1954
--  发布时间:2010/11/12 14:59:00
--  
谢谢啦,开始也用And 连接过,没成功。得到版主的确认后再试,仍然没有解决,就是那该死的括号和引号,现在终于搞成了。谢谢!