Summary Queries and Updates

[duffer 54]

I have a query that generates a summary for different sites, is it possible
to update fields in another table with the summaries generated in this query.

 

[[MVP] S.Clark]

You can create an update query based on another query, but sometimes you get
the dreaded "Must use an Updateable query" error. When that happens, I
write the data to a temp table, then base the Update Query on it, instead.

 

[duffer 54]

Thanks very much, I did have to make a table but this works fine forme.