Totaling An Aggregate Expression On A Report

[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.
====

 

[Bob Darlington]

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

 

[John W. Vinson]

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

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

 

[Bob Darlington]

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

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

Thanks for pointing that out John.
It was sloppiness on my part.

 

[John Spencer]

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

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

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

Thanks for pointing that out John.
It was sloppiness on my part.