Group Totals

[Guest]

In a MS Access report, I need to create Subtotals based on a particular
Group/Sort.

My report has 3 different Group/Sorts with the following relationships:
Group/Sort <--> Relationship
Claimant <--> Franchise
Site <--> Location
Specialty Seat Type <--> Product

I need to create Subtotals of the Specialty Seat Type grouped by Claimant.

To explain my current and desired situation, I’ll use the following
illustration:
I have a table that I’ll call tblFranchise.
In it are several fields including Claimant, Site and Specialty Seats.
I have a Query called qryClaimant based upon tblFranchise.
The criteria is [Enter Claimant:] on the Claimant field.
I have a report called rptProductTotals, with the RecordSource being
qryClaimant.
Sorting and Grouping has (3) levels (Claimant, Site & Specialty Seat Type).
a. Seat Type and Claimant each have a footer.
I have a text box with a control source on the Specialty Seat Footer
="Sub Total: Specialty Seat Type, " & [Claimant] & " at " & [Site] & " -- >
" & [SeatType]
I have a text box with a control source on the Claimant Footer
="TOTAL CUTOVERS for " & [Claimant]
Keep in mind that the Seat Type is a field of ‘different types’ of Seats;
therefore this Subtotal will be many different amounts -- per Seat Type --
which should be equal to the (1) Grand Total amount of Remaining Seats (that
is already displayed) on Claimant footer.

To reiterate, I want to display both my Subtotal of Specialty Seat Type
along with the Grand Total of Remaining Seats on the Claimant Footer.

I’ve already tried moving my Subtotal source code (as it is) to the Claimant
footer, but it does not work. That is, it does not give me the Subtotal ‘per
seat type.’

 

[Guest]

Anyway, following is a snapshot of a portion of my report as it is now.
http://home.comcast.net/~electroniclady/subtotal.jpg