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] "," ")

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

HTH,
David R

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

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

Should be Iif and not If which is vba