Office中国论坛/Access中国论坛

标题: 如何在联合查询只合计一个字段 [打印本页]

作者: luhao 时间: 2009-3-28 21:31
标题: 如何在联合查询只合计一个字段
如何在联合查询只合计一个字段

作者: chaojianan 时间: 2009-3-28 21:43
....
union
select "合计" as 销售订单,"" as 生产数量,"" as 单重,sum(重量) from 表;

作者: luhao 时间: 2009-3-28 22:05

....
union
select "合计" as 销售订单,"" as 生产数量,"" as 单重,sum(重量) from 表;
chaojianan 发表于 2009-3-28 21:43

这么快回复，谢谢你

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)