I thought I would be able to reference the resulting table from a Split, but perhaps not. I have a data field that comes in as FullName and is presented in a drop down. These names are in the format of Last, First, Title. I am using Left()-1 to successfully get the last name and store it in a variable, but what would the simplist way be to get the First name?
Thanks for the information
Solved! Go to Solution.