Search results

The Table is linked from somewhere else, I'll be back Mon Thanks you guys! I really appreciate your help!

Not my table design, I'll change it need be. Will a query match the a name in the report with a name in a table? How? The report is generated from a query, if that helps. I just can't formulate that one (query?) right now.

iif took away the "IF" parameter value request. The consultant name parameter value request remained. I want it to match each consultant name in the report with the consultant name in the table.

I will also try "iif" and see what happens, Thanks

I don't see the 4th reply on that other topic. Could you please repeat? There are a lot of consultant names in the Table with the addresses, etc., there are about 50 that mey or may not be in the table - that show up in the report. Thanks

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

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

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