split name into first name and surname

[tizwaz]

Can anyone see what I am doing wrong here

I have a field called Current Pass Holder which has a full name in it in the format Surname First Name

I have put the following code into a query - the surname comes out fine but the first name is sometimes ok and sometimes takes part of the surname as well

eg name shown as Garner Sarah has split as r Sarah Garner

FirstName: Trim(Right([Current Pass Holder],InStr([Current Pass Holder]," ")))

Surname: Trim(Left([Current Pass Holder],InStr([Current Pass Holder]," ")))

 

[dhookom]

Use Mid() not Right()
FirstName: Trim(Mid([Current Pass Holder],InStr([Current Pass Holder]," ")))


Duane
Hook'D on Access
MS Access MVP

 

[tizwaz]

thanks that works great now