Is there a way to total colums in a report? How?
R Rick B Jan 30, 2006 #2 Use the "SUM" function in a footer. See the help files for more details. I think the report wizard would help you total items as well.
Use the "SUM" function in a footer. See the help files for more details. I think the report wizard would help you total items as well.
D Duane Hookom Jan 30, 2006 #3 Regarding Rick's reply, Sum() works well in Footer and Header Sections. Sum() however, will not work in Page Headers and Footers.
Regarding Rick's reply, Sum() works well in Footer and Header Sections. Sum() however, will not work in Page Headers and Footers.
R Rick B Jan 30, 2006 #4 Duane: Good point! Thanks. -- Rick B Duane Hookom said: Regarding Rick's reply, Sum() works well in Footer and Header Sections. Sum() however, will not work in Page Headers and Footers. Click to expand...
Duane: Good point! Thanks. -- Rick B Duane Hookom said: Regarding Rick's reply, Sum() works well in Footer and Header Sections. Sum() however, will not work in Page Headers and Footers. Click to expand...
