How to seperate input from one field into two or more fields?

D

dnnll

I need to seperate a field input into two seperate fields. ex: <smith, john>
to <smith><john>. Access 2007 - thanks for any input
 
J

Jeff Boyce

If you are absolutely, positively certain that you will ONLY and ALWAYS have
"lastname comma space firstname", then you can use the Left() function and
the Mid() function to derive these values.

If you have compound last names (e.g., van De Kamp), suffixes (e.g., Jr.,
Sr.), multi-word first names (e.g., Mary Sue Ellen), or single word names
("Cher"), you will have a more difficult time getting 100% of your names
converted.

You may even have to rely on USB to finish after your conversion routine
gets the majority (using someone's brain, that is).

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Query that will look for duplicate in two tables. 3
How to extract parts of a field 4
can i separate a name field into 2 separate columns? 8
Excel Comparing two columns 1
seperate data in a field into two fields 2
Splitting a field 1
Compare mulitple fields in two tables 7
How do I split Names into 2 or more fields? 1

Top