Calculations in Access 2007 Reports

[Cheri Luoma]

I am creating a P/L in Access 2007 reports and have brought over all of my data and grouped and sorted by types with sum totals. I now want to take these totals and subtract one from the other but not sure how to do that. Any suggestions. I am really new at Access 2007 and if you could be really specific that would help.

EggHeadCafe - Software Developer Portal of Choice
Exchange UserCredential between client and webservice in.NET
http://www.eggheadcafe.com/tutorial...f-e3a718f0d96f/exchange-usercredential-b.aspx

 

[Lynn Trapp]

Cheri,
It's not easy to tell you exactly what to do without having more
information. However, if you have 2 field -- let's call them "Cost" and
"Price" -- that you sum in a group footer. To get the difference of them
summed up, you would put a text box in the footer with the following control
source =Sum([Cost] - [Price]). Feel free to post back with more information
if this doesn't answer your question.