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

D

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?
 
K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Field from Query Result 1
Select Query to create a Total field 9
Displaying summary level results from a query 8
No results when adding 2nd table to query 1
How to update data in a query 1
Use Update Query to Add Fields 1
Update query average from second table 1
Update Query using Table & Query 3

Top