Iif Then Else Statement

[hgwright]

I have a database where I have fields for First Name and Surname. In the FirstName field we list more than one name. I need to write a statement that will allow me to export this field with only the first name in it. I have found a statement that allows me to remove everything after the first name "(Left([FirstName],InStr(1,[FirstName]," ")-1)", but if they only have one name then this statement gives me an "#Error" message. Does anyone have any suggestions?

hgwright

[missinglinq]

This will check for the space first, then act accordingly.

 If InStr(1, [FirstName], " ") > 0 Then
  ExportFirstName = Left([FirstName], InStr([FirstName], " ") - 1)
Else
  ExportFirstName =  [FirstName]
End If

Welcome to Bytes!

Linq ;0)>

[hgwright]

In SQL you need something like :

IIf(InStr(1,[FirstName]," ")>0,Left([FirstName],InStr(1,[FirstName]," ")-1,[FirstName])