Help with mailing Labels = Company or name!!!

[Shadez]

I am creating mailing labels and need some assistance. If there is a company name in the company field I want this to be added to the report, but not name. Name only if the company field is not populated. So this one cell should be one or the other , but not both? Make any sense?

 

[CosmoKramer]

Change the control source for this field to something like this:

=IIf(IsNull([Company]), [Name], [Company])

 

[JaneC]

Hi,

If I've understood you correctly the following should work:

Create a text box on the label,datasource =

iif(isnull([CompanyName]) or [CompanyName]="",[Name],[Companyname])

So, if the Company Name is null or = "" then the control will contain Name, otherwise it will be Company Name

HTH

Jane

 

[Shadez]

Thanks a ton for the quick response, worked like a charm.