Update existing table with quantities from another table

[Budatlitho]

Hello:

I've struggled with this for quite a few hours, and it's time to ask for help.



Here's the SQL from my Access query:

UPDATE JumbulaMoniesQryNew RIGHT JOIN Symposium_member ON JumbulaMoniesQryNew.eid = Symposium_member.eid SET Symposium_member.amountdue = [JumbulaMoniesQryNew]![SumOfOrder amount], Symposium_member.amountpaid = [JumbulaMoniesQryNew]![SumOfPaid amount];

Running the query gives "Operation must use an updateable query"

Stumped in Plymouth MI...

[June7]

Access does not allow use of aggregate query as source for UPDATE action.

Usually, saving aggregate data is a bad idea. Risk of saved calcs getting 'out of sync' with data.

If it can be calculated for update, it can be calculated when needed.