C
Cass
I have a report that i'm creating that groups by Company. It looks
something like this:
Group Shipments
HM
0 2
1 3
2 4
3 5
Subtotals: 14
MA
58 6
59 7
60 8
Subtotals: 21
The groups are already filtered in a Query. Subtotals adds the total
shipments for each group. What we're trying to do is display the
totals before the query filtering the groups was applied. So I created
a separate query displaying the sums for each group & linked them to
my main query & we have something like this now where
99=SumofHMShipments:
Group Shipments
HM
0 2
1 3
2 4
3 5
Subtotals: 99
MA
58 6
59 7
60 8
Subtotals: 99
The reason 99 is displayed twice is because when I add the sums for HM
its also displayed under MA. I have separate sum fields that I need to
be displayed under MA. Can anyone offer me help on how to do this?
I thought maybe if I could figure out how to filter the Grouping by
Company displaying only HM & place the fields for its totals in only
its footer section, then I could do another group & filter by MA &
have separate footer sections for it to put the totals in.
The end result should be:
Group Shipments
HM
0 2
1 3
2 4
3 5
Subtotals: 99(field from Query of SumofHMShipments)
MA
58 6
59 7
60 8
Subtotals: 88(Field from Query of SumofMAShipments)
I hope this all makes sense I tried to be as detailed as possible!
Please help!
something like this:
Group Shipments
HM
0 2
1 3
2 4
3 5
Subtotals: 14
MA
58 6
59 7
60 8
Subtotals: 21
The groups are already filtered in a Query. Subtotals adds the total
shipments for each group. What we're trying to do is display the
totals before the query filtering the groups was applied. So I created
a separate query displaying the sums for each group & linked them to
my main query & we have something like this now where
99=SumofHMShipments:
Group Shipments
HM
0 2
1 3
2 4
3 5
Subtotals: 99
MA
58 6
59 7
60 8
Subtotals: 99
The reason 99 is displayed twice is because when I add the sums for HM
its also displayed under MA. I have separate sum fields that I need to
be displayed under MA. Can anyone offer me help on how to do this?
I thought maybe if I could figure out how to filter the Grouping by
Company displaying only HM & place the fields for its totals in only
its footer section, then I could do another group & filter by MA &
have separate footer sections for it to put the totals in.
The end result should be:
Group Shipments
HM
0 2
1 3
2 4
3 5
Subtotals: 99(field from Query of SumofHMShipments)
MA
58 6
59 7
60 8
Subtotals: 88(Field from Query of SumofMAShipments)
I hope this all makes sense I tried to be as detailed as possible!
Please help!