H
Howard
In a table, I have 5 fields, "Resource ID 1"
through "Resource ID 5". These are all lookup columns
which lookup the actual resource names in a resource
table. In a report, I want to print all 5 names underneath
each other, but only if they contain a value. Currently,
it prints 5 lines whether they have values or not.
The "Can Shrink" option is only available with text boxes,
not with the required combo boxes necessary to print the
actual name rather than the reference number. Therefore,
I am trying to concatenate all five values into a text box
fields on the report. The problem is, that it concatenates
the reference numberss into the text box, and not the
actual name it hopefully would have looked up. Please help!
Thanks! - Howard
through "Resource ID 5". These are all lookup columns
which lookup the actual resource names in a resource
table. In a report, I want to print all 5 names underneath
each other, but only if they contain a value. Currently,
it prints 5 lines whether they have values or not.
The "Can Shrink" option is only available with text boxes,
not with the required combo boxes necessary to print the
actual name rather than the reference number. Therefore,
I am trying to concatenate all five values into a text box
fields on the report. The problem is, that it concatenates
the reference numberss into the text box, and not the
actual name it hopefully would have looked up. Please help!
Thanks! - Howard