Having trouble with Calculated Field

[Clernix]

Hello All,



I am new to Access and teaching myself at home. I am working in the 2016 New Perspectives manual. I am trying to enter this in a calculated field ContactName: IIf( IsNull(NickName) , LastName & ", " & FirstName, Lastname & ", " & Nickname) but when I run the query it changes to ContactName: IIf(IsNull([NickName]),[LastName] & ", " & [FirstName],[Lastname] & ", " & [Nickname]) which makes it a parameter.


Any help is greatly appreciated.

[ranman256]

IF your fields are single words,(no spaces), using the brackets is the same as NOT using brackets
but its always best practice to always use brackets.

you WILL get a parameter if the field is spelled wrong.
or
the field does not exist. (which is a kind of misspelling)
or
you have an extra actual parameter in the query setting not getting fulfilled. (the parameter button on the toolbar)