select 字段1,字段2,字段3 from [Table] union (select 字段1+"小计" as 字段1,"" as 字段2, sum(字段3) as 字段3 from [Table] group by 字段3 ) order by 字段1
如果不借助于控件,直接用SQL语句行吗?
你总要显示出来啊,除非你在服务器端用T-SQL或用Print 及Debug.Print
有点误差: select 字段1,字段2,字段3 from [Table] union (select 字段1+'小计' as 字段1,' ' as 字段2, sum(字段3) as 字段3 from [Table] group by 字段1 ) order by 字段1
对,测试了一下能通过,谢谢!但如果我再在上述表中增加一条相同的记录 字段1 字段2 字段3 XX 101 10它会显示结果为: 字段1 字段2 字段3 XX 101 10 XX 102 20 XX小计 40 YY 101 5 YY 103 6 YY小计 11 如果我要求结果为这样可以吗? 字段1 字段2 字段3 XX 101 20 XX 102 20 XX小计 40 YY 101 5 YY 103 6 YY小计 11
select 字段1,字段2,sum(字段3) as 字段3 from [Table] group by 字段1, 字段2 union (select 字段1+'小计' as 字段1,' ' as 字段2, sum(字段3) as 字段3 from [Table] group by 字段1 ) order by 字段1
union (select 字段1+"小计" as 字段1,"" as 字段2, sum(字段3) as 字段3
from [Table] group by 字段3 ) order by 字段1
及Debug.Print
select 字段1,字段2,字段3 from [Table]
union (select 字段1+'小计' as 字段1,' ' as 字段2, sum(字段3) as 字段3
from [Table] group by 字段1 ) order by 字段1
XX 101 10它会显示结果为: 字段1 字段2 字段3
XX 101 10
XX 102 20
XX小计 40
YY 101 5
YY 103 6
YY小计 11 如果我要求结果为这样可以吗? 字段1 字段2 字段3
XX 101 20
XX 102 20
XX小计 40
YY 101 5
YY 103 6
YY小计 11
union (select 字段1+'小计' as 字段1,' ' as 字段2, sum(字段3) as 字段3
from [Table] group by 字段1 ) order by 字段1