Have a field with both first & last names, “Tom Jones” I want first & last names in 2-separate fields,First Name, “Tom”; Last Name, “Jones” Anyassistance will be greatly appreciated!
Have a field with both first & last names, “Tom Jones” I want first & last names in 2-separate fields,First Name, “Tom”; Last Name, “Jones” Anyassistance will be greatly appreciated!
FirstName: Left([NameField],InStr([NameField]," ")-1)
LastName: Mid([NameField],InStr([NameField]," ")+1)
Thanks Je! One more question, say I have the names 'yearsborn "1968" can I create a field ageborn from the 'yearsborn' field?
Can you post an example of the actual data layout and expected result.
Never mind,, I figured it out. Thanks again Joe!