请问以下的合计如何做？

sea.er

如果没猜错的话，是你把表的字段名搞错了，把“金额”写成了“合计”

zwmrp

是有问题会跳出楼的对话框
SELECT id, 产品, 单价, 数量, 金额 as 合计 FROM tblStudy
UNION
SELECT "总计:" AS id, "" AS 产品, "" AS 单价, "" AS 数量, SUM(金额) AS 合计 FROM tblStudy;
我是这样改的：
SELECT id, 产品, 单价, 数量, 合计 as 金额  FROM tblStudy
UNION
SELECT "总计:" AS id, "" AS 产品, "" AS 单价, "" AS 数量, SUM(合计) AS 金额  FROM tblStudy;

tanlangkun

那位兄台可以帮我改改一下，搞到我头都大了，都不行啊！
源文件：http://www.dgyinhai.com/forum/test.mdb
不胜感激！

[此贴子已经被作者于2004-1-7 10:30:40编辑过]

tanlangkun

多谢各位的回答，我做成功了。