Paul Hartland
paul.hartland at googlemail.com
Sat Jan 10 00:51:40 CST 2015
Can you not write another query based on the report dataset to just produce the sub totals then just export that query out to Excel ? On 10 January 2015 at 02:20, Brad Marks <bradm at blackforestltd.com> wrote: > > All, > > We have a rather complicated Access 2007 report that has a “Group” in > order to show sub-totals on about 10 fields. > > Recently, the manager of our Accounting Department has asked to have the > sub-total amounts placed in an Excel file as this is what an outside > accounting firm is asking for. > > I have other Access applications that populate Excel via Windows > Automation, so I understand this part. > > However, I don’t understand how to correctly grab the sub-totals. > > I have experimented with the “On Format” and “On Paint” events in the > Footer that contains the sub-total fields. > > When I look at these fields via a Msgbox, the Msgbox is shown multiple > times, therefore I don’t think that I can grab the sub-totals on either the > “On Format” or “On Paint” events. > > Is there a good way to capture sub-total fields? (make them available in > VBA code) > > Thanks, > Brad > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Paul Hartland paul.hartland at googlemail.com