1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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

    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

    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