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:
Running the query gives "Operation must use an updateable query"Code: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];
Stumped in Plymouth MI...