Sum Totals to an Access Report

[plaguna]

I created an Access report grouping by departments. Also a have Subtotals of the Sell-Price for each of 5 department. I have no problem to add all the Subtotals as a Grand Total, but my question is: How can I add or subtract the Sell-Price Subtotals of only two departments and not the 7 of them?. I looked for it everywhere and I tried all the possibilities I could. If you have any ideas, please let me know.

plaguna

[nico5038]

I created an Access report grouping by departments. Also a have Subtotals of the Sell-Price for each of 5 department. I have no problem to add all the Subtotals as a Grand Total, but my question is: How can I add or subtract the Sell-Price Subtotals of only two departments and not the 7 of them?. I looked for it everywhere and I tried all the possibilities I could. If you have any ideas, please let me know.

plaguna

You'll need to identify the departments you want to exclude.
Best with a field in the departments table like "CountForReport " YesNo.
Having such a field will allow you to create a report query to exclude these departments entirely, or to create an additional reporting column for totalling the Sell_price like:
[code=sql]
select IIF([CountForReport]=True,[Sell-Price],0) as SellPriceForTot al, ...
[/code]

Getting the idea ?

Nic;o)

[plaguna]

You'll need to identify the departments you want to exclude.
Best with a field in the departments table like "CountForReport " YesNo.
Having such a field will allow you to create a report query to exclude these departments entirely, or to create an additional reporting column for totalling the Sell_price like:
[code=sql]
select IIF([CountForReport]=True,[Sell-Price],0) as SellPriceForTot al, ...
[/code]

Getting the idea ?

Nic;o)

Nico5038,
Thank you for your help. This is exactly what i was looking for.
Thank you very much.

plaguna