1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Using a Query to split 1 record in to 3 records

Discussion in 'MS Access' started by CaboWaboScott, Mar 17, 2010.

  1. CaboWaboScott

    CaboWaboScott New Member

    Joined:
    Mar 17, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Greetings, I want to split the following record in to 3 records using a query.

    CCV DEPOSIT SEQ#1204BS1990 A-0000000802D

    End result would be
    CCV DEPOSIT
    SEQ#1204BS1990
    A-0000000802D

    I keep getting a syntax error when I try to create the split query. Any thoughts would be most helpful!!

    ~Scott
     
  2. apr pillai

    apr pillai New Member

    Joined:
    Dec 17, 2010
    Messages:
    16
    Likes Received:
    12
    Trophy Points:
    0
    Occupation:
    Auditor
    Location:
    India
    Home Page:
    Create a UNION Query with the following sample SQL:

    Code:
    SELECT Table1.Field1 FROM Table1
    UNION Table1.Field2 FROM Table1
    UNION Table1.Field3 FROM Table1
    
     

Share This Page