Rabu, 20 Januari 2016

[MS_AccessPros] Old timer problem


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?

Many thanks,

Robin Chapple


Posted by: Robin Chapple <robinski@westnet.com.au>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)



Tidak ada komentar:

Posting Komentar