Stuart McLachlan
stuart at lexacorp.com.pg
Tue Mar 20 22:50:25 CDT 2012
Nope, I'm on +10:00. it's just after lunch here 13:49 on Wednesday -- Stuart On 20 Mar 2012 at 20:24, Doug Steele wrote: > 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 >