Conditional Text In Text Box (1 Viewer)

[brucesilvers]

I have a report that gets its parameters from a form. Users have a choice of running the report for a particular trade group, or leaving the trade group blank to return all trade groups in the report.

The report title (in Report Header section)contains a text box that holds the Trade Group Name. If a user leaves the trade group blank to display all groups, I would like the Trade Group Name Text Box to display the words "All Trade Groups" rather than the actual Trade Group Name generated by the tables and queries feeding the report.

Is this possible? If so, any ideas on how?(I've tried an IIf statement that returns #Name? instead of "All Trade Groups")

 

[chrismcbride]

Bruce
See the Adding up Names posting. This will show you haw to get your count of records once on the report. Then it should be a relatively simple matter to put a text field in your Header that says

IIF([text_box_with_the_sum_of_records] > 1,
"All Trade Groups", [TradeGroupName])

Good Luck
Chris