Using a Query to split 1 record in to 3 records
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
I keep getting a syntax error when I try to create the split query. Any thoughts would be most helpful!!
Re: Using a Query to split 1 record in to 3 records
Create a UNION Query with the following sample SQL:
|All times are GMT +5.5. The time now is 10:30.|