select sum(十二月) from biao where right(业务类型,4) = '收入'
select sum(十二月) from biao where 业务类型 like '%收入'select sum(十二月) from biao where right(业务类型,4) = '数量'
select sum(十二月) from biao where 业务类型 like '%数量'
select sum(十二月) from biao where 业务类型 like '%收入'select sum(十二月) from biao where right(业务类型,4) = '数量'
select sum(十二月) from biao where 业务类型 like '%数量'
select sum(十二月) as xx from biao where 业务类型 like '%收入' and 业务类型<>'合计收入';
update biao set 十二月=:xxx where 业务类型='合计收入';
parameters.parambyname('xxx'):=Fieldbyname('xx');数量类似
上面代码没测试过哦