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/tutorials...dential-b.aspx

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.

--
Lynn Trapp


"Cheri Luoma" wrote:

> 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/tutorials...dential-b.aspx
> .
>