G Guest May 17, 2007 #1 I would like a count of all the records in a report as well as a sum of the amounts in a given field of the record. An average as well. Thanks.
I would like a count of all the records in a report as well as a sum of the amounts in a given field of the record. An average as well. Thanks.
G Graham Mandeno May 18, 2007 #2 In the footer section of your report, add three textboxes. Set their ControlSource properties respectively to the following expressions: =Count(*) =Sum([Amount Field]) =Avg([Amount Field])
In the footer section of your report, add three textboxes. Set their ControlSource properties respectively to the following expressions: =Count(*) =Sum([Amount Field]) =Avg([Amount Field])