Update query not updatable

[kpal29]

I have a query 'Subimport_Value' which is a query based on the tmpimport table wich is group on for all fields except 'value' which is summed.

I have another query 'update_subimport_value which is based on the 'subimport_value' query and is an update query which updates the 'value' field of the Subimport table.

I guess because my udpate query is based on a query that is grouped, it cannot update the field 'value'. I would like to avoid making another 'temp' table and using the recordset in vb which is slow. Any other solution?

 

[dhookom]

You can often use DSum() or other aggregate function to pull your summarized value.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

What is the SQL code of your Update query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886