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 Name".
Then I get an error when the report opens.
I want the statement to match the consultant name in the report with the consultant name in a different table.
See Report Data Statements, another topic I posted
=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 Name".
Then I get an error when the report opens.
I want the statement to match the consultant name in the report with the consultant name in a different table.
See Report Data Statements, another topic I posted