Parsing a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a name field that has the following format (Lname, Fname). I need to
extract Lname from the field and put it into another field. The LEFT fn
requires I know how many charectors to use. I need to be able to parse upto
the comma and extract/copy all of that data into the new field.

any and all ideas welcome... Thanks...
 
Not good at vba/sql but was able to put into access computed field name and
view in SQL. Code worked great.. thanks again....
 
Back
Top