Results 1 to 2 of 2
  1. #1
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    862

    Brain cramps

    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.

  2. #2
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    862
    Brain cramp fixed.
    Thx

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 10-09-2015, 12:06 PM
  2. Simple button on form (brain freeze!)
    By jhko in forum Forms
    Replies: 7
    Last Post: 02-27-2013, 05:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums