Group Footer Sum If Calc Controls

[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!

 

[Marshall Barton]

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.

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.