Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Calculations in Access 2007 Reports
0 views
Skip to first unread message
cheriluoma
Nov 19, 2009, 4:15:23 PM11/19/09
to
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/aspnet/5cbf012c-41f8-4133-a6bf-e3a718f0d96f/exchange-usercredential-b.aspx
Lynn Trapp
Nov 20, 2009, 1:17:01 PM11/20/09
to
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.
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:
> .
>
0 new messages