[AccessD] Field Totals

I replaced http://www.muir63.org/images/attendancetotal.jpg with a shot of what it looks like after following your suggestions. However, when I try to execute, I get:
"You tried to execute a query that does not include the specified expression 'last' as part of an aggregate function."

What next?

And thanks!

Kathryn


> -----Original Message-----
> From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg]
> Sent: 25 Jun 2003 3:19:PM
> To: Kathryn Bassett; accessd at databaseadvisors.com
> Subject: Re: [AccessD] Field Totals
> 
> 
> 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.
> 
> 
>