first name / last name

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

A name field has names listed 'Last Name, First Name' such
as "Smith, John". What expression can be used to reverse
the order to be 'First Name Last Name', thereby changing
the query (or report) result to be "John Smith"?

Any help is appreciated!
Kevin
 
Mid([NameField], InStr([NameField], ",") + 2) & " " & Left([NameField],
InStr([NameField], ",") - 1)
 
Back
Top