[AccessD] How to Grab Report Subtotals and Push them to Excel

Arthur Fuller fuller.artful at gmail.com
Sat Jan 10 05:42:22 CST 2015


Brad,

I agree with Paul. To look at the report itself is the wrong way to go
about it. Look instead at the data source of the report and query that
query to obtain the subtotals you want.

Arthur

On Sat, Jan 10, 2015 at 1:51 AM, Paul Hartland <paul.hartland at googlemail.com
> wrote:

> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Arthur


More information about the AccessD mailing list