hi,
An MSQ returns a recordset and dumps in into excel. once the MSQ has
finished, it kills the record set so there would be nothing in memory for you
to get to.
The dataset is on your sheet. you can summerize it via macro or formulas.
a second suggestion would be a second MSQ that brings in the summary data
via access query instead of access tables.(i am not sure which you first MSQ
uses. both a viable import media) If you do have a second MSQ then you can
set both MSQs to run back to back with a single click.
my thoughts.
regards
FSt1

"todtown" wrote:

I've been given a workbook that has a pivot table which gets its data
from an Access database by way of MS Query. Once the pivot table has
been updated it is sent to users who can view data based on the Month
and Year selected in the Page area.

I need to add a row that displays data outside of the pivot table,
based on the month and year the user has selected. The data I'm adding
is a summary of other data in the same dataset. I can capture the
month and year selected by the user, but I need to know how to access
the data. I'm thinking the data is in memory when the workbook is
being used. How do I get to it?

tod