parsing a text field 1

[kevinluebb]

I have a field in an imported table consisting of
FIRSTNAME/LASTNAME. I need to separate the first from the
last and put those into their respective fields within the
same table.

Not sure how this is handled in Access. I tried to use CHARINDEX in an update routine but can't seem to get the
syntax correct.

 

[Maquis]

FirstName: Left(Name,Instr(Name,"/&quot-1)

LastName: Right(Name,Len(Name)-Instr(Name,"/&quot)

You can put those calcs in the update to line in your query design. Maq B-)
<insert witty signature here>