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

unread,
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

unread,
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.

--
Lynn Trapp


"Cheri Luoma" wrote:

> .
>

0 new messages