Group Footer Sum If Calc Controls

  • Thread starter Thread starter George Hammett
  • Start date Start date
G

George Hammett

I have a detail section of info where I need to provide
two sum numbers; one to sum all positive values and one to
sum all negative values...simply done in excel as a sumif
statement but I can't figure out how to do it in
Access...report is filtered.

Thanks!
 
George said:
I have a detail section of info where I need to provide
two sum numbers; one to sum all positive values and one to
sum all negative values...simply done in excel as a sumif
statement but I can't figure out how to do it in
Access...report is filtered.
Click to expand...

Use an expression Like:

=Sum(IIf(thefield >= 0, thefield, 0))

for the positives and a similar expression for the
negatives.

Not that whatever you use for "thefield" must be a field in
the report's record source table/query, not a control on the
report.
 
Back
Top