[AccessD] Field Totals

Stuart McLachlan stuart at lexacorp.com.pg
Wed Jun 25 17:19:18 CDT 2003


On 25 Jun 2003 at 14:48, Kathryn Bassett wrote:

> OK, I've now been successful in parsing out my single attendance field into individual fields.
> http://www.muir63.org/images/attendancetotal.jpg
> 
> I have database that gives me a total across, but not down, but I
> don't need that here. I need a total of all the attendance fields -
> for instance, the total number of people who attended the 25th. I
> don't even need a fancy report or anything, just something that gives
> me the total. In a spreadsheet, I would just say @SUM(B1..B50)) to
> total the 50 records in column B. How do I get that figure here (where
> B is "attend25"). 
> 
> I've looked in the help file, and tried the pivot table query wizard
> but I get a block that looks like a spreadsheet but no further wizard
> to say what next. 
> 

In the Query Builder, got to the menu and tick "View-Totals". 

You will then see another row in the grid labelled "Total:" 

All the entries initially will be "Group By". 
Delete the unique fields from the query (First, Last,Married)
Change the entries for the Attendance fields to "Sum" .  
Voila!


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.





More information about the AccessD mailing list