多个数据表汇总为数据透视表后列字段不求和，请大家帮忙解决一下，谢谢

jucuifang888

工作中需要统计一些猪的书，我想把各个圈舍的数据汇总，又要知道把每个圈舍的数据，我就做了一个数据透视表，但是做成之后有几个列段不求和，请大家看后帮忙解决一下，谢谢，

zzzdbg

楼主的版本太高我没法看，帮不了

suwenkai

用SQL函数帮你解决了。参考一下。

1. select
   
2. 类型,
   
3. 圈号,
   
4. iif(母猪 is not null,val(母猪),0) as 母猪,
   
5. iif(未断奶仔猪 is not null,val(未断奶仔猪),0) as 未断奶仔猪,
   
6. iif(断奶仔猪 is not null,val(断奶仔猪),0) as 断奶仔猪,
   
7. iif(均重 is not null,val(均重),0) as 均重,
   
8. iif(总重 is not null,val(总重),0) as 总重 from
   
9. (SELECT "七栋" as 类型, * FROM TABLE1 UNION ALL
   
10. SELECT "六栋", * FROM TABLE2 UNION ALL
    
11. SELECT "五栋", * FROM TABLE3 UNION ALL
    
12. SELECT "四栋", * FROM TABLE4 UNION ALL
    
13. SELECT "三栋", * FROM TABLE5 UNION ALL
    
14. SELECT "二栋", * FROM TABLE6 UNION ALL
    
15. SELECT "一栋", * FROM TABLE7)

复制代码

zcxqwef

真不知为什么会这样