How do you delimit an access text field so data that was once:
ID Field 1 Field 2
1 Gerry Baseball, Soccer, Swimming
To:
ID Field 1 Field 2
2 Gerry Baseball
3 Gerry Soccer
4 Gerry Swimming
any suggestions?
