I am trying to string three fields together, I think I am missing something. I have three fields that I need to pull from. The first field and third field are required (First_Name and Surname), but we also have a field, called Maiden. So some of rows don't have Maiden filled in.
So I came to this syntnax -
=IIf(IsNull([Maiden]),[First_Name] & " " & [Surname],[First_Name] & " " & [Maiden] & " " & [Surname])
Basically - If Maiden is null, then the result should be First_Name Surname, otherwise, First_Name Maiden Surname
Why does it kept giving me an error - #Type!
Any help would be greatly appreciated.
Thanks
Shannon