Office 97

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I am using Office 97 Access & I wish to seperate into another field the Last
Name. At the moment the name field is e.g. Mr*R*Thompson. How can this be
done?

Bruce
 
I am using Office 97 Access & I wish to seperate into another field the Last
Name. At the moment the name field is e.g. Mr*R*Thompson. How can this be
done?

Bruce
Click to expand...

Well... it depends. How much variation is there within this field?
What is stored if there is no first initial, or no title, or if the
person has a two word last name such as Van Cleef, or if the person
uses both first and middle initials?

You'll be using the Mid() and InStr() functions but it's not clear
exactly how, depending on whether the name always contains exactly two
asterisks, or sometimes none, one, or three.

John W. Vinson[MVP]
 
Back
Top