error "Operation must use an updateable query"

M

Manrao

I am updating a query 'ALFA'

The update fails because the field I am updating
from 'Dollar' is a calculated sum from another
query 'BETA'.

The only solution I see is to make 'BETA' a table
And then run the update query 'ALFA'

Is there a better way to do this? Without creating so many
tables?
 

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.

Ask a Question

Similar Threads

Updates for excel 2002/3 0
Error: Operation must use an updatable query 2
Access update query 2
update query vs make query 5
Update query error: "Operation must use an updateable query" 1
Operation must be an updatable query 8
Update Query - Operation must use an updateable query 3
Operation must use an updatable query 1

Top