SumIf equation in report

  • Thread starter Thread starter JessicaMtgt
  • Start date Start date
J

JessicaMtgt

I would like to translate the following Excel formulas into Access report
expressions:

=SUMIF(D3:D485,">0",(D3:D485))
=SUMIF(D3:D485,"<0",(D3:D485))

In my Access report "D3:D485" represent my field [Amount]. I am trying to
see the report totals by debits and credits.
 
I would like to translate the following Excel formulas into Access report
expressions:

=SUMIF(D3:D485,">0",(D3:D485))
=SUMIF(D3:D485,"<0",(D3:D485))

In my Access report "D3:D485" represent my field [Amount]. I am trying to
see the report totals by debits and credits.
Click to expand...

In the section that displays the[Amount] field (the Detail Section?)
add an unbound text control.
Set it's Control source to:
=Sum(IIf([Amount]>0,[Amount],0))

Add another control:
=Sum(IIf([Amount]<0,[Amount],0))
 
Perfect - Thank you fredg!!!!!!

fredg said:
I would like to translate the following Excel formulas into Access report
expressions:

=SUMIF(D3:D485,">0",(D3:D485))
=SUMIF(D3:D485,"<0",(D3:D485))

In my Access report "D3:D485" represent my field [Amount]. I am trying to
see the report totals by debits and credits.
Click to expand...

In the section that displays the[Amount] field (the Detail Section?)
add an unbound text control.
Set it's Control source to:
=Sum(IIf([Amount]>0,[Amount],0))

Add another control:
=Sum(IIf([Amount]<0,[Amount],0))
Click to expand...
 
Back
Top