Report Data Statements

[premonde]

I want to have my report show the address, phone, and contact name from one table,
IF the company name (in the table) = the company name in the "Group By" field of the report.
Statement I've tried-
=IF([CONSULTANT NAME]=[Consultant]![Consultant Name]," [Consultant]![Contact Person 1] and [Consultant]![Phone] and [Consultant]![Mailing Address] "," ")

 

[David R]

Use the & operator instead of And to join fields in one text box. And is a Logic operator, & is text manipulation.

HTH,
David R

 

[premonde]

Getting a "parameter value" request for IF and Consultant name

 

[JCollins]

I have had problems in the past with spaces in a field name...That may be part of the problem.

 

[Rich]

Should be Iif and not If which is vba