Please offer why the following does not work for removing a Last Name field of any characters after the first space, going from left to right:
Left([Last Name],InStr([Last Name]," ")-1)
and this does not work for the First Name field as well, with Last Name replaced by First Name.
My understanding is that for Last Name, we begin from the left, go to the space, and then move back one to get all the characters prior to the space.
Last Name and First Name are two different fields.
Hope this makes sense.