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

  • Thread starter Thread starter dnnll
  • Start date Start date
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
 
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
 
Back
Top