first name / last name

[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

 

[Cheryl Fischer]

Mid([NameField], InStr([NameField], ",") + 2) & " " & Left([NameField],
InStr([NameField], ",") - 1)