Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    santa clara
    Posts
    25

    Unanswered: Updating a table from a query

    I'm trying to update a table which hold some rebate information. I have a query which I parsed some data out and holds the information which I need to update the table... My SQL is below

    UPDATE Approved_Details_Table INNER JOIN rcf_good ON Approved_Details_Table.Rebate_Approved_ID = rcf_good.Rebate_Approved_ID SET Approved_Details_Table.Check_Date = [rcf_good]![checkdate], Approved_Details_Table.Check_Number = [rcf_good]![checknumber], Approved_Details_Table.Mail_Date = [rcf_good]![maildate], Approved_Details_Table.Check_Amount = [rcf_good]![amount], Approved_Details_Table.Outsourced = True, Approved_Details_Table.Paid = True
    WHERE (((Approved_Details_Table.Rebate_Approved_ID)=[rfc_good]![Rebate_Approved_ID]));

    It keeps telling me Operation Must Use An Updateable Query.

    rfc_good is the query which holds the data which I'm trying to update the Approved_Details_Table.

    Thank you.

  2. #2
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Re: Updating a table from a query

    Originally posted by pokermagic
    I'm trying to update a table which hold some rebate information. I have a query which I parsed some data out and holds the information which I need to update the table... My SQL is below

    UPDATE Approved_Details_Table INNER JOIN rcf_good ON Approved_Details_Table.Rebate_Approved_ID = rcf_good.Rebate_Approved_ID SET Approved_Details_Table.Check_Date = [rcf_good]![checkdate], Approved_Details_Table.Check_Number = [rcf_good]![checknumber], Approved_Details_Table.Mail_Date = [rcf_good]![maildate], Approved_Details_Table.Check_Amount = [rcf_good]![amount], Approved_Details_Table.Outsourced = True, Approved_Details_Table.Paid = True
    WHERE (((Approved_Details_Table.Rebate_Approved_ID)=[rfc_good]![Rebate_Approved_ID]));

    It keeps telling me Operation Must Use An Updateable Query.

    rfc_good is the query which holds the data which I'm trying to update the Approved_Details_Table.

    Thank you.
    Well, first make sure you have the porper MySQL syntax!!

    [rcf_good]![maildate] is Access syntax... Won't wok in MySQL!

  3. #3
    Join Date
    Oct 2003
    Location
    santa clara
    Posts
    25
    ooops sorry.. wrong category.

Posting Permissions

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