I have been away from Access work for more that a year and age has
warped my memory.
I nee to add the field "PartnerFirstName" to a query and I have
failed. I cannot even find an example from another database.
This is my failed attempt:
NameFull: [LastName] & ", " & [FirstName] & IIf([PartnerFirstName] Is
Null," ",(" [PartnerFirstName] "))
What have I missed?
Posted by: Robin Chapple <email@example.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (1)|