我在"销售"数据表中运用
设置[%销售数量2%]: SumFor("销售","销售数量","日期",">=",[%日期1%],"日期","<=",[%日期2%],"门店","=",[门店],"课别","=",[课别])
然后在"课别销售"表中运行
ShowAllRows() and if(format([%日期1%],"yyyymmdd")="" or format([%日期2%],"yyyymmdd")="",msgbox("开始日期和结束日期必须都选择,可以是同一天!",1,1),if(format([%日期1%],"yyyymmdd")<>"" and format([%日期2%],"yyyymmdd")<>"" and [%日期1%]>[%日期2%]=true,msgbox("开始日期不可大于结束日期,请重新选择!",1,1) and SetVariable("%日期1%","") and SetVariable("%日期2%",""),true)) and if([%课别%]>"",FilterFor("课别","=",[%课别%]),True) And if([%门店%]>"",FilterFor("门店","=",[%门店%]),True) And EvalFor("课别销售","店_销售数量","[%销售数量2%]")
但是始终不执行,不知道为什么,请给予帮助,谢谢!(另:我将文件上传,希望大家帮助
RAR文件下载RAR文件下载