Group Subtotals

[Donna Miller]

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).
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.’

Here is a snapshot of a portion of the report: http://home.comcast.net/~electroniclady/subtotal.jpg

 

[Ziggy1]

Try with the Claimant control in the Claimant Group Header section.

Put Specialty Seat Type in the Detail section

And Subtotal of Specialty Seat Type in the Claimant Group Footer section, as Sum([Specialty Seat Type])

Or as Count([Specialty Seat Type])

Place the grand total in the Report Footer section, same as the Sum/count noted above.