Storing data from a query to a table

[Guest]

I need to store data from a calculation in a query to a table. The idea is
to have a totals column for that data in the table. I was successful at
having a calculations formula in my query but now I need the data stored in
the main table. Any suggestions?

 

[Joseph Meehan]

First, it is not a good design to store computed data in a table.
Access works much better by just re-computing it each time it is needed.

If you really want to store it in a table, then you use a append -
update query.