Sum Function on a Group, but Displayed on Another Group

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Electronic Lady - 26 Oct 2005 02:42 GMT

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.

Note: If this question is not clear, please ask for clarification.

Thank you!!!

Reply to this Message

Larry Linson - 26 Oct 2005 04:59 GMT

A Sum or Count of SeatTypes used as Control Source of a Text Box in the
Claimant Footer should be all it takes to give you what you want.

Larry Linson
Microsoft Access MVP

> In MS Access, On a Report:
>
[quoted text clipped - 22 lines]
>
> Thank you!!!

Reply to this Message

Electronic Lady - 31 Oct 2005 15:33 GMT

Larry,
I already have a Sum of Seat Types used as Control Source of a Text Box in
the
Specialty Seat Type Footer which works fine, but when I move it the Claimant
Footer it does _not_ work. Perhaps it’s because of the way my report is
Grouped and Sorted. See my explanation above and below. Anyway, following
is a snapshot of a portion of my report as it is now.
http://home.comcast.net/~electroniclady/subtotal.jpg
You'll notice that the Subtotal of Specialty Seats is displayed on several
lines by Site, and the Total of Remaining Seats is displayed after all the
Subtotals. The Total Remaining Seats is a total sum of all seats by Claimant.
The report Groups/Sorts
Claimant/Site/Specialty Seats
Have a relationship such as the following example:
Claimants = Franchise
Site = Location
Specialty Seats = Products
As I mentioned earlier, I want to continue to subtotal the Specialty Seats,
however, not by Site but by CLAIMANT.
The control source code (see above post) that I have on the Specialty Seat
footer does not work correctly when I move it to the Claimant footer. This
is where my next question to you comes in………

How would I write the code that you suggest? Please let me know if I should
be more specific.

Thank you!

> A Sum or Count of SeatTypes used as Control Source of a Text Box in the
> Claimant Footer should be all it takes to give you what you want.
[quoted text clipped - 28 lines]
> >
> > Thank you!!!

Reply to this Message