Parsing a field

[RPLanWizard]

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...

 

[mscertified]

Dim P as integer
P=instr(MyName,",")
Lname = left$(MyName,P-1)

-Dorian

 

[RPLanWizard]

Thanks

Dim P as integer
P=instr(MyName,",")
Lname = left$(MyName,P-1)

-Dorian

 

[RPLanWizard]

Not good at vba/sql but was able to put into access computed field name and
view in SQL. Code worked great.. thanks again....