I have just imported a long list of client names which includes single names and joint names into an Access database table.
Initially I would like a routine which actually separates the table of account names from the names into separate fields and assign the corresponding account number and addresses to it and create a new table with the new records. The logic that so far I can see is as follows:-
a] starting from the left the surname will be anything before the first comma.
b] the first name will be anything before the character before "&" or "&/Or" .
c] and so on until no more of the characters "&" or "&/Or" are in the field.
I am attaching an excel file which best depicts what I am trying to achieve.
Thanks, grateful for the assistance.