report data field

[premonde]

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

 

[mbentley]

Maybe it was just a typo in your posting, but you need to use "iif" not "if". I think it means "immediate if". At least that's how I remember it.

Mike

 

[Rich]

See the answer I gave and also how many Names could a consultant have? Try and explain.

 

[premonde]

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

 

[premonde]

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

 

[premonde]

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.

 

[Rich]

Use a query?

 

[mbentley]

I'm not sure, as I don't put spaces in my field names, but I think you have to enclose your field names in quotes if you do use spaces. Unfortunately I can't remember exactly where the quotes go, but it shouldn't take long to find the right spot by trial and error.

At the risk of sounding patronizing, it's a good idea to avoid spaces in field names altogether for this very reason.

Mike

 

[mbentley]

Just looked at Rich's last post. Maybe it's my imagination, but my reports seem to perform better (i.e. faster) if I keep as many calculations as possible in the underlying query.

 

[premonde]

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.

 

[premonde]

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