Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006
    Posts
    1

    Unanswered: updating table data from a query

    I need to be able to update the data value in a numeric field in a table named family, where the value comes from the count of a text field from the member table. The query contains the family and member tables. Every time I try to run the update query, I get the message Operation must use an updateable query. What am I doing wrong? Can I even make this work? Please help.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Why are you storing derived data?

    Also, you cannot update a query that uses joins and/or does not reference a primary key, as access does not know what record of which table to update.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •