[AccessD] Field Totals

Ah, I misunderstood. Thought you meant to delete the GroupBy vs changing to Sum. Yes, deleting the field entirely worked like a charm. I now have the four totals I need and will be able to quickly do the totals for the 40th next month.
176	25	177	85

Thanks again!

--
Kathryn Rhinehart Bassett (Pasadena CA)
"Genealogy is my bag" "GH is my soap"
kathryn at bassett.net
http://bassett.net  		

> -----Original Message-----
> From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg]
> Sent: 25 Jun 2003 3:40:PM
> To: Kathryn Bassett; accessd at databaseadvisors.com
> Subject: RE: [AccessD] Field Totals
> 
> 
> On 25 Jun 2003 at 15:34, Kathryn Bassett wrote:
> 
> > 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?
> > 
> You forgot the other part of last message:
> "Delete the unique fields from the query (First, Last,Married)"
> 
> 
> -- 
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System Support.
> 
> 
>