Subtotal not working

[alvintse]

Hi,
I have a quarterly report with the grouping as below:

Agency (Group header)
center (group header)
department (group header)
item(group header)
detail section: mon itemName total amount
total for the department (department footer)
total for the center (center footer)
total for the agency (agency footer)

The report returns the correct result as long as the item for the department display on the same page. Whenever it split into 2 pages, it added the total amount one more time.

Please help!

 

[dhookom]

How are you calculating subtotals? Are you using code somewhere rather than the standard method of creating totals in reports?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[alvintse]

Yes. I am usinc code to add the total amt at the detail section.

 

[dhookom]

Why? Totals are normally created without code. You should be able to use control sources like:
=Sum([A Numeric Field or Expression])
or
=Count([Any Field or Expression])

If you have something special about your report then you need to tell us about it. This would include your code and why you are using it.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]