Access update Query to separate full name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to separate a NAME field which has the last name followed by a
comma followed by the first name. Could you give me the function (s) that I
need to place the Last name in a field called Lname and the first name in a
field called Fname?

Thank you
 
You can use an update query with functions like Instr(), Left(), Mid(), and
Right(). For instance to get all characters to the left of the first ",",
you would use
Left([YourField], Instr([YourField], ",") -1)
You can use Mid() to get everything right of the ","

Come on back if you can't figure this out.
 
Back
Top