Help with Immediate IF expression...

[DBNewYork]

Can someone shed some light on what's wrong with this expression:


IIf([Primary Lname]=[Secondary Lname],[Primary Fname] & " & " & [Secondary Fname] & [Primary Lname],IIf(IsMissing([Secondary Lname]),[Primary Fname] & " " & [Primary Lname],[Primary Fname] & " " & [Primary Lname] & " & " & [Secondary Fname] & " " & [Secondary Lname]))

What is happening is Access keeps deleting the last 2 parenthesis and then pops up an error box saying that I a parenthesis is missing from the expression???????

Thanks in advance for any advice. - DB

[MAK]

I ran this in access as query. it ran fine. i think you have some parenthis or "" or & in the data itself

SELECT IIf([Primary Lname]=[Secondary Lname],[Primary Fname] & " & " & [Secondary Fname] & [Primary Lname], IIf(IsMissing([Secondary Lname]),[Primary Fname] & " " & [Primary Lname],[Primary Fname] & " " & [Primary Lname] & " & " & [Secondary Fname] & " " & [Secondary Lname])) from table3