Converting text in one column to four columns

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separate data in one column into four columns 3
Other backgroundcolor by another value in the same column 1
How to Fill Empty Cells with Data from Previous Records 1
VBA Conditional formating for specific text in several columns 1
Text To Columns in Access 18
In Cell Formula to mimic text to columns. 3
Adding data in columns based on criteria in more than one column.. 6
Somewhat complex 'group by' query 2

Top