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
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