Trim Last Name

[Bill B.]

How can I retrieve the last name only from a field formatted like First Name,
Space, Last Name (John Smith)? TIA

Bill B.

 

[Jeff Boyce]

Bill

Parsing a FullName field to get last name only is not an insignificant
undertaking.

First, are you quite certain you have no middle names/initials?

Do you have any lastnames that are "compound" (e.g., Williams-Smyth, Johnson
Brackston, van de Wegge, ...)? How do YOU know where firstname ends and
lastname begins?

You may need to "do your best" with functions like Left(), Right(), Mid(),
Instr() in queries, then manually clean up what didn't automatically
convert.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP