Query to display three names

[Slim Shamble]

Hi

I have 3 textboxs for first name, middle name and last name. And I want to display the names entered in this textbox. I try using this code below but its shows only the first and the last name.
Full name: IIF(IsNull([First Name],IIF([First Name]),[First Name]), IIF(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]))

But this code only display just the first and last name. How do I get it to work also for middle name. That is to display First, Middle and Last Name.

 

[Ranman256]

select [FIRST] & " " & IIF(iSNULL([MIDDLE]),"", [MIDDLE] & " ") & [LAST] AS NAME FROM TABLE

 

[Slim Shamble]

Didn't work. Got an error saying

The syntax of the subquery in the expression is incorrect, check the subquery's syntax and enclose the subquery in parentheses. I don't understand that

 

[arnelgp]

its simple as this:

([First Name] + " ") & ([Middle Name] + " ") & [Last Name]

 

[Slim Shamble]

Thanks Guys, thanks arnelgp. Your code work perfectly.