T
Tom Lake
As long as the first name and last name will always be separated by exactly one blank
and there will be no middle initials this should do it (I call the field MyName but
you have to sbustitute your own field name):
Fname: Trim(Left([MyName], Instr([MyName], " ")))
Lname: Trim(Mid([MyName], Instr([MyName], " ") + 1))
Tom Lake
and there will be no middle initials this should do it (I call the field MyName but
you have to sbustitute your own field name):
Fname: Trim(Left([MyName], Instr([MyName], " ")))
Lname: Trim(Mid([MyName], Instr([MyName], " ") + 1))
Tom Lake