Update table from Totals query

[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

 

[John Spencer (MVP)]

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.