ACCess 分别对多个字段值求和

[freepw]

selcet id,sum(字段1) as tj1,sum(字段2) as tj2,sum(字段2) as tj3,sum(字段3) as tj4,sum(字段4) as tj5,sum(字段5) as tj6,sum(字段6) as tj7,sum(字段7) as tj8,sum(字段8）from table GROUP BY id



这样做好麻烦，可以精减？

[ACMAIN_CHM]

没有办法，只能这样写。 一般可以在EXCEL通过公式快速生成这个SQL语句。

[freepw]

引用 楼主 freepw 的回复:

selcet id,sum(字段1) as tj1,sum(字段2) as tj2,sum(字段2) as tj3,sum(字段3) as tj4,sum(字段4) as tj5,sum(字段5) as tj6,sum(字段6) as tj7,sum(字段7) as tj8,sum(字段8）from table GROUP BY id 这样做好麻烦，可以精减？

有tj3--tj20.... <% for x = 3 to rs.Fields.Count-1 %> <td align="center"><%=rs("tjx")%></td> 这个X变量怎么引入进去。。。 <% next %>

[ACMAIN_CHM]

<%=rs.fields(x)%>

[wwwwb]

rs("tj" & x)

[freepw]

引用 4 楼 wwwwb 的回复:

rs("tj" & x)

谢谢回复