Access支持select用来update吗?

ddtkld

附件“生成DateMoney”的SQL能改成下面的方式吗？

update datesum set daymoney =
(select order.goodsnum * goods.price
from order, goods
where order.orderdate = datesum.orderdate and
            goods.goodsid = order.goodsid
)

也就是说使用select来update

请各位DX多多指点

Grant

UPDATE Goods INNER JOIN ([Order] INNER JOIN DateSum ON Order.OrderDate = DateSum.OrderDate) ON Goods.GoodsID = Order.GoodsID
SET DateSum.DateMoney = order.goodsnum*goods.price;

Access Update 不支持子查询

ddtkld

谢谢版主指点。

我还有另外一个问题，搭一下顺风车：
http://www.office-cn.net/vvb/thread-61888-1-1.html
请版主指点