Search results

I'm still having trouble with this statement =IF([CONSULTANT NAME]=[Consultant]![Consultant Name]," [Consultant]![Contact Person 1]&[Consultant]![Phone]&[Consultant]![Mailing Address] "," ") I'm now getting a parameter value request before the report opens, one for "IF" and one for "Consultant...

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...