Results 1 to 2 of 2
  1. #1
    Join Date
    May 2015
    Posts
    1

    Unanswered: Duplicate rows with a column content

    I would like to use Access in order to duplicate the content of a list of values into new rows based on the content of a column.

    Here is an example below:

    List1 List2
    A 1
    B 2
    C 3
    D 4
    E 5
    F 6
    G 7

    Duplication
    A1
    A2
    A3
    A4
    A5
    A6
    A7
    B1
    B2
    B3
    B4
    B5
    B6
    B7
    Etc

    How can I achieve this in Access?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Consider using a UNION ALL query
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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