Hi all, thank you in advance for your help. I have a Yes/No Field titled "andfamily". What I am trying to do is, when the "Yes" field is clicked, that ", and family" will be added to the "Last Name" field on the report/labels. I have written code in the query that works, but I can not get it to work on the report. The query code is Expr1: IIf([andfamily]=True,", and Family ",""). The labels code without the ", and family" added is =([Salutation]+" ") & ([NameonEnvelope]+" ") & [Last Name]. The code on the label, which does not work is, =([Salutation]+" ") & ([NameonEnvelope]+"") & ([Last Name]+" ") & [IIf([andfamily]=True,",and Family " & [Last Name],"")]
Could someone please tell me what I am doing wrong. At this point, I am lost. Thank you so very much.
Maurita