By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,406 Members | 2,660 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,406 IT Pros & Developers. It's quick & easy.

Sum Totals to an Access Report

P: 58
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
May 21 '08 #1
Share this Question
Share on Google+
2 Replies


nico5038
Expert 2.5K+
P: 3,072
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:
Expand|Select|Wrap|Line Numbers
  1. select IIF([CountForReport]=True,[Sell-Price],0) as SellPriceForTotal, ...
  2.  
Getting the idea ?

Nic;o)
May 21 '08 #2

P: 58
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:
Expand|Select|Wrap|Line Numbers
  1. select IIF([CountForReport]=True,[Sell-Price],0) as SellPriceForTotal, ...
  2.  
Getting the idea ?

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

plaguna
May 23 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.