Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    17

    Unanswered: Insert RECORDS in a single table

    I would like to Insert records in the same table.
    Example:
    TABLE before:
    Fields: Name1, Name2
    1 1
    1 2
    2 3
    2 2
    3 1
    TABLE after:
    Fields: Name1, Name2
    1 1
    1 2
    2 3
    2 2
    3 1
    4 1
    4 2
    5 1
    5 2
    I have inserted four new records (copied from the first records)

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    There is nothing in Access or SQL to prevent you from running a query that selects from TableA into TableA. You will need to provide the logic for incrementing your key values.

Posting Permissions

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