JeffBarker
Registered User.
- Local time
- Today, 17:18
- Joined
- Dec 7, 2010
- Messages
- 130
Hi guys,
I'm trying to return Mr Stevenson (if we're missing the First Name), Mr James Stevenson (if we have the First Name) or James Stevenson (if we're missing the person's Title) as an alias in an Access query, but can't quite get it right.
This is what I currently have:
Contact: IIf(IsNull([First Name]),[Title] & " " & [Surname],[Title] & " " & [First Name] & " " & [Surname]) Or IIf(IsNull([Title]),[First Name] & " " & [Surname])
But all it returns is -1.
Can anyone assist, sil vous plait??
Thanks,
Jeff.
I'm trying to return Mr Stevenson (if we're missing the First Name), Mr James Stevenson (if we have the First Name) or James Stevenson (if we're missing the person's Title) as an alias in an Access query, but can't quite get it right.
This is what I currently have:
Contact: IIf(IsNull([First Name]),[Title] & " " & [Surname],[Title] & " " & [First Name] & " " & [Surname]) Or IIf(IsNull([Title]),[First Name] & " " & [Surname])
But all it returns is -1.
Can anyone assist, sil vous plait??
Thanks,
Jeff.