Update query error: "Operation must use an updateable query"

L

LarissaR

Hello, community!
I work for a hospital that is collecting data on patients for a small study.
I have one table with my list of patients and another table (pulled from
another source) that contains heaps of data on these patients and more. Not
all of the patients in my small table will have data in the huge one.
I'm attempting to use an update query to enter the max value for my patients
into my small table from the large one, but I get the error, "Operation must
use an updateable query." I'm sure I need to give you more information than
this, but I'm not quite sure what else is needed. Could you please advise?
Thank you for your time.
 
V

vanderghast

Change the aggregate MAX to the VBA function DMax. A query with an
aggregate is NOT updateable.

Vanderghast, Access MVP
 

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

Update query error: "Operation must use an updateable query." 3
Update query error: "Operation must use an updateable query" 8
Must use an Updateable Query - Issue 0
Update Query - Operation must use an updateable query 3
Operation must use an updateable query 13
Add a new field that enters Y or N 1
"Operation must use an updateable query" 2
Operation must use an updateable query 4

Top