语句为:
select *,(select sum(货款结存) from [数据源$a1:v349] a2 where a1.客户=a2.客户) as 应收账款 from [数据源$a1:v349] a1
说明 :先安装Excel2007,后又装了一个excel2003;用2007出现这个上面两个提示,用2003也出现上面两个提示
无奈,卸载了2003,重装了2007,还是这样
但奇怪的是,同样的命令这个表可以正常使用语句:select *,(select sum(货款结存) from [数据源$a1:v111] a2 where a1.客户=a2.客户) as 应收账款 from [数据源$a1:v111] a1 数据源.zip(25.64 KB, 下载次数: 20)
透视表样式为什么是上图左边格式,而不是右边格式
select *,(select sum(货款结存) from [sheet2$a1:v15] a2 where a1.客户=a2.客户) as 应收账款 from [sheet2$a1:v15] a1 透视表样式不对.zip(48.87 KB, 下载次数: 12)