Update table from query results

[primagic]

I have a query that retrieves AccountNumber, SumofFees, SumofTotal.

I have a table with the fields - AccountNumber, Fees, Total. AccountNumber is populated with AccountNumber data. These accountnumbers may appear in the query.


I want to take the results from the query and update the table with the sumoffees - fees field, sumoftotal - total field.

Any ideas?

 

[dhookom]

If the "I have a query" is not updateable (totals or union or other) then you can't create an update query using it.

If you have a good reason to store sums and totals, you can possibly append to a temporary table with a primary key of AccountNumber. Then use the temporary table to update your "table with the fields...".

Duane
Hook'D on Access
MS Access MVP

 

[primagic]

Hi.

I have created a temp table that puts the results from the query into it. Then I run the update query against that table. works now

Thanks