请教ACCESS中UPDATE的问题

UPDATE CmpMoney SET AdMoney = 1
WHERE CmpMoney.CardID =
(SELECT addCardId, sum(adMoney) AS [SumMoney]
FROM addmoney
GROUP BY addCardId
having CmpMoney.CardID = addCardId.addCardId
);

我在Access中打算用如上语句来将CmpMoney 表中的AdMoney 字段值更新成SumMoney的值，
应该怎么写呢？

谢谢了先。。。