对于复制本月数据,用下列公式,可以防止数据重复复制。大家可以试一试。
If(CountFor("全年数据","月份"," = ",[月份]) >= 2,MsgBox("本月数据已保存,如需更改,请删除原有月份数据!",0), AppendFor("本月数据","序号,姓名,年度,月份,计税收入","序号,姓名,年度,月份,计税收入") and delfor(gridname,"姓名","=","") and RecalcGrid(gridname) and msgbox("数据复制完成!",0))