splitting a field

[tgl]

I have a database including full name:
prefix firstname middlename lastname

some fields have a prefix and/or middlename some do not.
How can i pull out just lastname

i assume it's some variation on right() and instr() but can't seem to do it.

 

[Steve Schapel]

Tgl,

Mid([Full Name],InStrRev([Full Name]," ")+1)

(assumes the LastName does not contain a space, i.e. this will not work
for Joe Di Maggio)

 

[tgl]

Thanks! so easy when you know how!!
tgl

Tgl,

Mid([Full Name],InStrRev([Full Name]," ")+1)

(assumes the LastName does not contain a space, i.e. this will not work
for Joe Di Maggio)

--
Steve Schapel, Microsoft Access MVP

I have a database including full name:
prefix firstname middlename lastname

some fields have a prefix and/or middlename some do not.
How can i pull out just lastname

i assume it's some variation on right() and instr() but can't seem to do it.