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



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?



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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question