If statement for Query Maybe???

[Gretchen]

Here's my problem:

I have OrgName field in a form. The subform on this form has the actual CtrName field. The CtrName field is only filled in if it is different from the OrgName. When pulling the query for labels, I need the query to pull the correct name (address/city/state/zip will be same for both). If the CtrName is blank, I need the query to use the OrgName. If the CtrName is completed, I need the query to use that field rather than the OrgName. This sounds like an If statement to me; but that's beyond my knowledge. How can I get this to work for my users?

Thanks

 

[Mile-O]

You'd be better to look up the Nz() function in the help.

 

[neileg]

Try LabelName: IIf(Nz(CtrName,"")="", Orgname,CtrName)

 

[Gretchen]

Thanks so much to you both! I'll try these and if I get too lost, I'll post again *grin*

 

[Gretchen]

Thank you!!

Thank you Mile-O-Phile and Neileg!!! A big hug to you Neileg for the exact wording! *hugs* You have made my user's day!!! (as well as mine) Thanks again !!!