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.
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.
Thanks very much, I did have to make a table but this works fine forme.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.