Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    I need an updatable query (2000)

    I'm trying to prepare a query that should update the TARGET field in the CONSUNTIVO table in the attached mdb for the date selected in the CGior calendar in the CONS form by drawing the updating data from a subquery but when I run the query I get the message: "To carry out the operation you need an updatable query".
    How can I modify the Consuntivo Query so as to be able to perform the update?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: I need an updatable query (2000)

    You're trying to update the Target field to a select statement. That makes no sense, the select statement might return more than one value. Does this do what you want?

    UPDATE Previsioni INNER JOIN Consuntivo ON (Previsioni.Ora = Consuntivo.Ora) AND (Previsioni.Giorno = Consuntivo.Giorno) SET Consuntivo.Target = ([termica]+[brembana]+[scalve]+[seriana]+[palazzolo])-([rezzato]+[calusco]+[sede])-[Prev]
    WHERE (((Consuntivo.Giorno)=[forms]![cons]![cgior]));

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: I need an updatable query (2000)

    Hans, amico mio. Thank you very much.
    Another piece of magic on your part!

Posting Permissions

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