separating and the concatenating a field

  • Thread starter Thread starter Melo
  • Start date Start date
M

Melo

I am trying to separate a field that has:

lastname, firstname

I need to reverse these 2 so it is:

firstname lastname

I can do it in Excel but towards the end of the month the file is too large
to put into excel to do this.
I am not sure how to do it in Access.

Thanks,

Mel
 
Assuming that the name is ALWAYS two parts and is always split by a comma
then the following should work

Field: Fn_Ln: Trim(Mid([FullName],Instr(1,[FullName],",") +1)) & " " &
Left([FullName],Instr(1,[FullName],",")-1)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top