If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Are these calculations possible?
I have a report made up of multiple investment funds. I have totaled the
amount for each individual fund in the group footer which is the way the client wants it. The clincher is they want the total from one of the funds to show that it is subracted and then added to a different fund. FUND NUMBER TOTAL 1 5,000 2 5,500 3 7,000 SUB TOTAL 17,500 LESS FUND #1 5,000 TOTAL 12,500 What I want to know is how to I specify one particular piece of information? Thanks, Sue |
#2
|
|||
|
|||
Are these calculations possible?
You should be able to get the figure for your "Less Find #1" box by placing
it in the group footer, and giving it a Control Source like this: =Sum(IIf([Fund Number]=1, [Total], 0) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "skr" wrote in message ... I have a report made up of multiple investment funds. I have totaled the amount for each individual fund in the group footer which is the way the client wants it. The clincher is they want the total from one of the funds to show that it is subracted and then added to a different fund. FUND NUMBER TOTAL 1 5,000 2 5,500 3 7,000 SUB TOTAL 17,500 LESS FUND #1 5,000 TOTAL 12,500 What I want to know is how to I specify one particular piece of information? Thanks, Sue |
Thread Tools | |
Display Modes | |
|
|