这张汇总表用透视表怎么做(多表汇总)

eliubing

根据产品编号来做 后面费用的汇总

用透视表怎么做

谢谢

guangzhizi

用论坛里的select应该就能实现吧,...........

penghaifeng

select * from ['0601$'] union all select * from ['0602$'] union all select * from ['0603$'] union all select * from ['0604$']  union all select * from ['0605$']  union all select * from ['0606$']  union all select * from ['0607$']  union all select * from ['0608$']  union all select * from ['0609$']  union all select * from ['0610$']  union all select * from ['0611$']  union all select * from ['0612$']


另外,楼主12个月份数据依然有不统一的标题,个别月份列数我已经删除,否则无法用查询语句.

[ 本帖最后由 penghaifeng 于 2009-3-26 15:38 编辑 ]

eliubing

谢谢 我想问一下 外部数据 属于函数应用 还是什么啊