let me see if I can reword my question or better express what I need. I have a report grouped by [Product] and I set the select statement to ask for 'Wood' or 'Veg', but I also need 'Vegr'. However When the grouping shows up on the report I just need to group by Wood and Veg and show the tonnage for each (which it does)but in the report footer I also need the sum of the tonage for the records that have 'Vegr' as the [Product]. I think that expresses what I need a bit clearer. Anyone know how to get the total tonage for a [Product] that is not included in the grouping?
Non Grouped Totals
- Thread starter rschultz
- Start date
Similar threads
