Converting text in one column to four columns

E

Ernie Sersen

I have text in one Access Query column separated by dashes and I want to
separate it into four new Access Query columns. Record one may contain
aaa-bbb-ccc-ddd; record two may contain aaaa-bbb-ccccc-dd; etc. I need the
a's, b's, c's and d's all in their own columns.
 
R

Rick B

Ernie:

You just got an answer to this in your other post in the Queries newsgroup.
Check out that post.


Rick B
 
Top