The following statements work if the name field only is separated by a comma, but I have found instances where it is separated by a dot as well.
FName = Left([First Name], InStr([First Name], ",")-1)
LName = Right([First Name], Len([First Name]) - InstrRev([First Name], ","))
I have tried to change the "," to be ",",".",""))
I also can run this, followed by a separate replace query for the dot, but I am wondering if there is an easier way.