Help Needed: Create Sum in Report Footer based on aggregate expression

[amywolfie]

Access 2007:
I have an expression on a report where Control Source
=IIf([Geo]=1,[Deeds Docs Backplant]-Sum([DocsDEED]),IIf([Hist]=1,[Hist
Exp Deed Est]-Sum([DocsDEED])))

This works fine.

I want to put a Sum() of this in the report footer. But because
there's an aggregate in the expression, I keep getting bounced. I
tried re-creating it on the query driving the report, but when I Sum
this in the footer, I get absurdly large numbers.

Does anyone have a solution for this?
Thanks.
====

 

[John Spencer]

Have you tried using that expression as the control source of a control in the
report footer (not page footer)? If that doesn't work, perhaps you can use
the following expression.

Control Name: txtGrandTotal
Control Source: = Sum(IIF([Geo=1],[Deeds Docs Backplant]
,IIF{[Hist=1,[Hisp Exp Dead Est],0)))-
(Sum([DocsDeed])* Abs(Sum([Geo]=1 Or [Hist=1])))


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County