Hi,
I have a field called StudentEmergencyName
The name can either be a single name like 'Mr J Edgar' or a couple eg
'Mr J Edgar and Mrs M Jones' or Mr J and Mrs M Jones'
I need to find out which of these 3 versions it could be and then based on this I need to strip out the names into either one or two.
This is so I can use the end result to search for an ID for each individual.
Need to do this because there is no relationship between the two tables I need to link together to get other information, except through the name.
Any ideas what formaula I can use to do the first part of stripping out the names?
IP Logged