Update table from Totals query

  • Thread starter Thread starter Brian T.
  • Start date Start date
B

Brian T.

We are trying to take a value from a Totals query and
insert it via 'update query' into a table.

But when I try to create an Update Query and bring the
table and the Totals query into it, it locks the records.

Any idea how I can use the Totals query's fields to
update the table without locking all the records?

BT
 
You cannot use a totals query in Access in an UPDATE query.

You can try using the aggegate functions DSUM, DCOUNT, DAVG, etc?

Or you can dump the data into a temp table and then use the temporary table to
update your table.
 
Back
Top