Splitting Fields

  • Thread starter Thread starter HankW
  • Start date Start date
H

HankW

I have a field that currently contains "Last Name, First Name". How can
I split apart the "Last Name" and the "First Name" based on the comma?
In excel I can use the find function, what can I do to replicate that
in Access?
 
Hi,


InStr(string, substring) could be use to find the first position of the
substring in the string.


Left( string, InStr( FullName & "," , ",") -1)


and


Mid( string, InStr( FullName & "," , ",") -1)


could split the field accordingly to the presence of the first coma.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top