select id,val from A order by id compute sum(val) by idOK?????????/
不行呀。我是在Access2002里用的。好像没有Compute
select id,val from tableA union select id+'合计' as id,sum(val) as val from tableA order by id
select id,val from tableA union select id+'合计' as id,sum(val) as val from tableA group by id order by id
seelct iif(ordertype=2,'合计'+id,id) as id,val from ( select id,val,1 as ordertype from tableA union all select id as id,sum(val) as val,2 as ordertype from tableA group by id ) as a order by id,ordertype
order by id
compute sum(val) by idOK?????????/
union
select id+'合计' as id,sum(val) as val from tableA
order by id
union
select id+'合计' as id,sum(val) as val from tableA group by id
order by id
from (
select id,val,1 as ordertype from tableA
union all
select id as id,sum(val) as val,2 as ordertype from tableA group by id
) as a
order by id,ordertype