Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008

    Unanswered: append query help -> add to existing record instead of creating new

    INSERT INTO SdtPack ( [LIB section] )
    SELECT SectStd.sectionCODE
    FROM SectStd INNER JOIN SdtPack ON SectStd.studentID = SdtPack.SID
    WHERE (((SectStd.sectionCODE) Like "ANC*"));
    The SQL above creates a new record instead of inserting the data according to SID. Its like SectStd.studentID = SdtPack.SID is being ignored entirely. I also tried having SectStd.studentID = SdtPack.SID in my where but that didn't work either.

    How do I change the code above to get it to insert the sectionCODE into the right record?

    Table "SectStd" has fields "sectionCODE" and "StudentID"
    Table "SdtPack" has fields "Lib Section" and "SID"


  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Insert queries add records.

    Update queries modify records.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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