Sum per Group but Display on Another Group

[Donna Miller]

In MS Access, On a Report:

I want a total on a group of records. Whats more, I want to subtotal this group of records, but add the text box to another group's footer.

How can I do this?????

My current code looks like the following, and it works as long as the text box is on the same group that I'm adding up. But that's not what I want. As I said above, I want my text box on the another group.

= "Sub Total: Specialty Seat Type," &[Claimant] &"-->" &[SeatType]

BTW, my Grouping is as follows:

1st level: Claimant
2nd level: Site
3rd level: SeatType

I want to add the total amount of SeatTypes (per Claimant/Site), and show the Sum on the Claimant footer level.

 

[Pat Hartman]

Sounds like you're trying to do a recap. Make a separate report to produce the totals and add it as a subreport to the footer section.

 

[Donna Miller]

Please explain

Pat,

I'm very much a novice.....I'm self taught. Can you give me an overview of the other report?

Please, and thanks!!!

Donna