[AccessD] Unusual Sub Totals Needed on Access 2007 Report

Darryl Collins darryl at whittleconsulting.com.au
Tue Mar 20 22:50:55 CDT 2012


Nah... It is afternoon for him, Lounging around in the jungle like he does.. ;)



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Wednesday, 21 March 2012 2:25 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Unusual Sub Totals Needed on Access 2007 Report

So what time is it at your location, Stuart?  Aren't you up early?

Doug

On Tue, Mar 20, 2012 at 8:21 PM, Stuart McLachlan <stuart at lexacorp.com.pg>wrote:

> How about:
> In the Report Footer, have a field  =SUM(IIF(GROUP = "Group-2" or 
> GROUP =
> "Group-3",Amount,0))
>
>
> On 20 Mar 2012 at 22:03, Brad Marks wrote:
>
> > All,
> >
> > I am working on a report that has a need for rather unusual sub-totaling.
> >
> > I will use a simple test example to explain what I am trying to do.
> >
> > The data for the report comes from a query with only two fields "Group"
> and "Amount".
> >
> > There are three groups, Group-1, Group-2, Group-3.
> >
> > The report needs to have sub-totals for each Group.  This is easy.
> >
> > Now the tricky part.  The report also needs a total for Group-2 and
> Group-3 added together.
> >
> > Is there an easy way to do this?
> >
> > Is there some way to capture select sub-totals for later use?  If I 
> > can
> capture the amounts, I can build the extra sub-total into one of the 
> footers.
> >
> > Thanks,
> > Brad
> >
> >
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
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