Formula Help

[Lee-Anne Waters via AccessMonster.com]

Hi,

i have a table that contains names like leeanne.waters

what i need to be able to do is use a formula to extract the first name only
(ie everything before the dot.)

many thanks for your help

Lee-Anne

 

[fredg]

Hi,

i have a table that contains names like leeanne.waters

what i need to be able to do is use a formula to extract the first name only
(ie everything before the dot.)

many thanks for your help

Lee-Anne

FirstName = Left([FullName],InStr([FullName],",")-1)

 

[Lee-Anne Waters via AccessMonster.com]

many thanks