Doug Steele
dbdoug at gmail.com
Tue Mar 20 22:24:32 CDT 2012
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 >