I have a small table (7 fields) placed in the REPORT FOOTER using the table tool.
The first field in the table is [Office]. When I select "define field" after using the table tool, I select [Office] from the drop down list. No problem here. Then I do the same for the reamining 6 fields.
What I need is the value in the [Office] field to print in bold if it equals a specific name, ie. "THE SMITH COMPANY." the rest of the values to print normally.
How I do this in the RECORD BAND portion of the report is to place a new field directly over the exhisting field in the record band and make it a calculated field with the following:
IIF([CBSDCARLSBADLINK.Office]="THE SMITH COMPANY","THE SMITH COMPANY",""). This works perfectly in the record band but fails in the report footer.
Any ideas on how to accomplish this?
Thanks . . . Rick