Using a Query to split 1 record in to 3 records

CaboWaboScott's Avatar, Join Date: Mar 2010
Newbie 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
apr pillai's Avatar, Join Date: Dec 2010
Go4Expert 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