how can i convert text to columns in access query

L

Lionel

I have a text in a query and i need to separate
ex: Peter John Ramos that is on column i need to sepate by the spaces like

column 1 column 2 column3
Peter John Ramos
 
F

fredg

I have a text in a query and i need to separate
ex: Peter John Ramos that is on column i need to sepate by the spaces like

column 1 column 2 column3
Peter John Ramos
Click to expand...

And how would you expect to separate Jean Louis van den Steen III?
Or George Stewart?
or ... etc.
 

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

Split column contents (de-concantenate) 7
Need help transposing multiple columns in a query 0
Can I convert text to columns in a query? 2
query 2
SQL to query columns that are in seconds since 1/1/1970 6
Extract part of text 5
Transforming empty fields into "0" in a query 3
Setting Fieldname in query with a combobox 6

Top