I have a report that contains records in the detail section of the report. In each record is a number field named "txtCount". Then in the footer of that group I would like to have a field that has the max number from the "txtCount" number in the detail section.
In other words, if the detail records look like:
Record 1 5
Record 2 7
Record 3 12
Record 4 4
Then the number I want to show in the footer is 12.
How can I do this? What is the control source for the field in the footer?