各位好:上传文件“汇总表”的汇总数据查询按钮,可以生成汇总行,统计出次数和补助金额的总和。按钮公式如下:ClearGrid(GridName) And AppendRows("表1","m","=",[%a%]) And DelRow(GridName,1) And Subtotal("","次数,补助金额","2,2"And SetLabel(" ",Cell(Rows,"次数")) And SetLabel(" ",Cell(Rows,"补助金额"))
但是按钮公式如下汇总行确无法统计出补助的人员数,
ClearGrid(GridName) And AppendRows("表1","m","=",[%a%]) And DelRow(GridName,1) And Subtotal("","次数,补助金额","2,2","姓名","4,2") And SetLabel(" ",Cell(Rows,"次数")) And SetLabel(" ",Cell(Rows,"补助金额")) And SetLabel(" ",Cell(Rows,"姓名"))不知错在那里,请指教。谢谢!!
egd文件下载