Always getting "Operation must use an updateable query."
Code:UPDATE Data INNER JOIN Query1 ON Data.ID = Query1.ID SET Data.Networks = [154Anet] WHERE (((Data.Networks)=IIf([Data].[id]=[query1].[id],[154Anet],[Networks])));
I want to update the field [Network] in the table [Data] where Data.ID equals Query1.ID with information from the field [154Anet] in Query1.
I'm having a terrible brain cramp for something so simple.