Change Name to Last Name, First using a query

Use these functions in an update query:

Name: Right([Distributed To],Len([FullName])-InStr([FullName]," ")) & ", " & Left([FullName],InStr([FullName]," ")-1)

Of course this wont work well with those with a middle name...

Of course, you should save names as separate fields; lastname, firstname, middlenamesorinitial, etc.

A real name object should be something like this: surname, givennamefirst, givennamemiddle, calledbyname --- anything else? Or how about priorsurname (for the married or otherwise who have changed their name since employeement.