[AccessD] Totals on a report?

Stuart McLachlan stuart at lexacorp.com.pg
Fri May 17 00:22:18 CDT 2013


In the report footer,place three textboxes below the three Attend columns

=SUM([Attend Friday]) 
=SUM([Attend Dinner Sat]) 
=SUM([Attend Sunday]) 

(Or whatever the field names are for those three columns.)

-- 
Stuart

On 16 May 2013 at 16:09, Kathryn Bassett wrote:

> Access 2010
> 
> https://www.dropbox.com/s/0nbj0oq6k2ypqti/50th%20attendance.pdf  The report
> is based on a query called "50th attendance". 
> 
> I have a query called "Attendance with all totals - no report" that tells me
> there are 42 Fri, 51 Sat, and 38 Sun. On the last page of the "50th
> attendance" report, I want those totals. Is that possible, and if so, how?
> 
> --
> Kathryn Rhinehart Bassett (Pasadena CA)
> "Genealogy is my bag" "GH is my soap"
> kathryn at bassett.net
> http://bassett.net   
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 





More information about the AccessD mailing list