Multiple Group Headings in Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that does bid estimates for our company. It lists all the
subprojects (bids) within an overall project (master project) and totals them.

Master Project
Subproject1
List of Items & Prices
Subtotal 1
Subproject2
List of Items & Prices
Subtotal 2
Grand Total

Now I want to add an alternate bid. But I want it to have a separate grand
total. It will be under the same master project but will have no relation to
the subprojects. I want it to show at the same group level as the
subprojects but under a different group header. Is this possible? I just
need to know how to set up the groupings. If I get that far, I can figure
out the calculations. It would look like this:

Master Project
Subproject1
List of Items & Prices
Subtotal 1
Subproject2
List of Items & Prices
Subtotal 2
Total of Subprojects

Alternate1
List of Items & Prices
Subtotal Alt 1
Alternate2
List of Items & Prices
Subtotal Alt 2
Total of Alternates

Thanks.
 
Looks lik you need to arrange for the report's record source
query to include a field for regular vs. alternate
estimates. Then you can add another level in sorting and
grouping. The estimate grand total would go in this new
group's footer instead of the master project footer.
 
Back
Top