#error returned from page subtotal

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
M'al said:
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.
Click to expand...


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).
 
Back
Top