• Problem with QRY statement

    Author
    Topic
    #476961

    I’m having trouble with the following statement:

    CurrentDb.Execute “INSERT INTO tblOT SELECT tblOTemp.* FROM tblOTemp”

    The attached pic shows that tblOTemp has 13 records in it but tblOT behind it shows that only 6 (in this case) have been copied over.

    Any Ideas anyone? On other occasions I have had all, 1, 2, 4 records copied over but it should be a consistent 13 (employees).

    Viewing 0 reply threads
    Author
    Replies
    • #1281485

      The failures result probably because the OTID value in those inserted records already exist and I presume OTID is unique.

      CR

    Viewing 0 reply threads
    Reply To: Problem with QRY statement

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: