以文本方式查看主题 - 易表在线答疑 (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 连接过,没成功。得到版主的确认后再试,仍然没有解决,就是那该死的括号和引号,现在终于搞成了。谢谢! |