#Error handling query (1 Viewer)

thefunkyfarm

New member
Local time
Today, 16:56
Joined
Aug 29, 2012
Messages
2
Hi - First post for me here.
I'm trying to split out the first name from a GivenNames field which contains first and middle names. Some values in the GivenNames field have just a first name. I've tried the below formula, but still get some #Error responses where only a first name exists in the field. It's probably just a bracket in the wrong place, but some help would be great.

My formula:
Given Name: IIf(IsError(Left([GivenNames],InStr([GivenNames]," ")-1)),[GivenNames],Left([GivenNames],InStr([GivenNames]," ")-1))
 

dansc0tt

Registered User.
Local time
Yesterday, 23:56
Joined
Aug 29, 2012
Messages
13
try IIf(InStr([GivenNames]," ")=0,[GivenNames],Left([GivenNames],InStr([GivenNames]," ")-1))
 

thefunkyfarm

New member
Local time
Today, 16:56
Joined
Aug 29, 2012
Messages
2
... yep, cheers - that seemed to work.
 

Users who are viewing this thread

Top Bottom