Totaling An Aggregate Expression On A Report

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

amywolfie

Hi:

I have a field on a report where Data Source =

=IIf([Hist Exp Deed Est]>0,Sum([DocsDEED]))

I need to get a TOTAL of this field in the Report Footer, but Access
won't let me Sum an aggregate. I've tried creationg the total on the
query, but no luck.

Can anyone help?

Thanks.
====
 
amywolfie said:
Hi:

I have a field on a report where Data Source =

=IIf([Hist Exp Deed Est]>0,Sum([DocsDEED]))

I need to get a TOTAL of this field in the Report Footer, but Access
won't let me Sum an aggregate. I've tried creationg the total on the
query, but no luck.

Can anyone help?

Thanks.
====
Click to expand...

Try =Sum(IIf([Hist Exp Deed Est]>0,Sum([DocsDEED]))) in the Total field in
the footer
 
amywolfie said:
Hi:

I have a field on a report where Data Source =

=IIf([Hist Exp Deed Est]>0,Sum([DocsDEED]))

I need to get a TOTAL of this field in the Report Footer, but Access
won't let me Sum an aggregate. I've tried creationg the total on the
query, but no luck.

Can anyone help?

Thanks.
====
Click to expand...

Try =Sum(IIf([Hist Exp Deed Est]>0,Sum([DocsDEED]))) in the Total field in
the footer
Click to expand...

Bob, shouldn't IIF have three arguments not two? Try

=Sum(IIf([Hist Exp Deed Est]>0,Sum([DocsDEED])),0)
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
John W. Vinson said:
amywolfie said:
Hi:

I have a field on a report where Data Source =

=IIf([Hist Exp Deed Est]>0,Sum([DocsDEED]))

I need to get a TOTAL of this field in the Report Footer, but Access
won't let me Sum an aggregate. I've tried creationg the total on the
query, but no luck.

Can anyone help?

Thanks.
====
Click to expand...

Try =Sum(IIf([Hist Exp Deed Est]>0,Sum([DocsDEED]))) in the Total field in
the footer
Click to expand...

Bob, shouldn't IIF have three arguments not two? Try

=Sum(IIf([Hist Exp Deed Est]>0,Sum([DocsDEED])),0)
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
Click to expand...

Thanks for pointing that out John.
It was sloppiness on my part.
 
I think the expression should be

=Sum(IIF([Hist Exp Deed Est]>0,[DocsDEED],Null))


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

John W. Vinson said:
Hi:

I have a field on a report where Data Source =

=IIf([Hist Exp Deed Est]>0,Sum([DocsDEED]))

I need to get a TOTAL of this field in the Report Footer, but Access
won't let me Sum an aggregate. I've tried creationg the total on the
query, but no luck.

Can anyone help?

Thanks.
====

Try =Sum(IIf([Hist Exp Deed Est]>0,Sum([DocsDEED]))) in the Total field in
the footer
Click to expand...

Bob, shouldn't IIF have three arguments not two? Try

=Sum(IIf([Hist Exp Deed Est]>0,Sum([DocsDEED])),0)
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
Click to expand...

Thanks for pointing that out John.
It was sloppiness on my part.
Click to expand...
 
Back
Top