#error returned from page subtotal

[Guest]

Hi,

I want to subtotal data per page. It works correctly to subtotal the groups
and the report, but the page subtotal returns #error for both count and sum
functions. I have played with running sum over group and over all and the
best I can get is a subtotal of 0.

Any ideas?

 

[Marshall Barton]

I want to subtotal data per page. It works correctly to subtotal the groups
and the report, but the page subtotal returns #error for both count and sum
functions. I have played with running sum over group and over all and the
best I can get is a subtotal of 0.

The aggregate functions do not operate at the page level,
only at the group an report level.

For a way to calculate page subtotals, see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;296249&Product=acc2002

Even though that article says it's for A2002, it will work
for all versions (the A2000 version of this article is not
reliable in any version).

 

[Guest]

Thank you SOOO much! That worked perfectly!

Thank you for the response!