The database I am working on has a field named Firstname and within that field one or two names can be inputted, I wish to extract only the first of these names. I entered the following into the field of a the query.
KnownAs: Left([FirstName],InStr([FirstName]," ")-1)
The result as shown below is ok when there are two names in the field , however when there is only one name I receive and error #Func!
ClientNumber...... KnownAs........FirstName
100058...................John .................. John Charkas
100059..................#Func!............... Richard
I am missing something and would like assistance
Regards Ypma
KnownAs: Left([FirstName],InStr([FirstName]," ")-1)
The result as shown below is ok when there are two names in the field , however when there is only one name I receive and error #Func!
ClientNumber...... KnownAs........FirstName
100058...................John .................. John Charkas
100059..................#Func!............... Richard
I am missing something and would like assistance
Regards Ypma