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