I am brand new to VB. I have a simple MS Access 2000 application.
I currenly have no functions or subs.
I need a function to find the last name in a name field.
My input string is in the following sequence. First Name, Middle Name or initial, Last Name and generational title. There are no validations done to validate the sequence. Hence multiple formats are present
MIKE A BATES JR
MIKE ADAM BATES JR
M A BATES
MIKE A BATES
MIKE BATES JR
MIKE A BATES, JR
MIKE BATES, JR
Of course I am looking for a string that has BATES in it.
You can probably come up with more combinations.
This is a problem that I am sure has been solved many times before.
I would appreciate any help anyone can provide on this.
Thanks in advance.