premonde
02-01-2002, 01:39 PM
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
02-01-2002, 01:47 PM
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
See the answer I gave and also how many Names could a consultant have? Try and explain.
premonde
02-01-2002, 02:02 PM
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
02-01-2002, 02:03 PM
I will also try "iif" and see what happens, Thanks
premonde
02-01-2002, 02:06 PM
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.
mbentley
02-01-2002, 02:18 PM
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
02-01-2002, 02:29 PM
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
02-01-2002, 02:42 PM
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
02-01-2002, 02:49 PM
The Table is linked from somewhere else, I'll be back Mon
Thanks you guys! I really appreciate your help!