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

  • Thread starter Thread starter amywolfie
  • Start date Start date
A

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.
====
 
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
 
Back
Top