How to use the results from a runing total query to update a table

[Dougie]

I have created a form for a gliding club membership database which correctly
displays balances owing against each member using a running total query. I
would like to update a transaction table with these values but the query
will not run as an update query. Is there anyway to extract and store these
values?

 

[Klatuu]

Your question is a little vague, but if what you are saying is you want to
calculate an amount and then store that in a table, the answer is don't do
it. You should never store calculated values. They only waste time and disk
space and eventually will probably be incorrect.

If you can describe what your objective is, perhaps we can help with a
solution.