查询结果不一样

lilianban

帮忙看一下，为什么查询里的客户发货和联合查询结果的借方金额会不一样，实际金额应为18440才对，怎么会变成11720元呢出错在哪里，谢谢

[此贴子已经被作者于2007-1-15 8:19:49编辑过]

wangf

tbl_出库单.出库单 = tbl_出库单明细.单号;

[tbl_出库单明细]![单价]*[tbl_出库单明细]![数量] AS 金额 ,"借方"

如果单价和数量都相同的两组值，在你的条件下，它就只能显示一组值，当然会不一样喽!

换个条件吧!

lilianban

怎么换，帮忙改一下好不？

lilianban

我在ACCESS爱好者论坛有人帮我改了，具体如下

联合查询  中的条件更改下：

SELECT tbl_期初表.客户编号, tbl_期初表.日期,tbl_期初表.摘要,tbl_期初表.金额 as 金额,"期初余额" as 备注,"产品编号" as 产品编号
FROM tbl_期初表;

UNION SELECT tbl_出库单.客户编号, tbl_出库单.日期,tbl_出库单.摘要,[tbl_出库单明细]![单价]*[tbl_出库单明细]![数量] AS 金额 ,"借方" as 备注,tbl_出库单明细.产品编号
FROM tbl_出库单 INNER JOIN tbl_出库单明细 ON tbl_出库单.出库单 = tbl_出库单明细.单号;

UNION SELECT tbl_货款表.客户编号, tbl_货款表.日期,tbl_货款表.摘要,tbl_货款表.金额 AS 金额,"贷方" as 备注,"产品编号" as 产品编号
FROM tbl_货款表;