SumIf equation in report

[JessicaMtgt]

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

=SUMIF(D3485,">0",(D3485))
=SUMIF(D3485,"<0",(D3485))

In my Access report "D3485" represent my field [Amount]. I am trying to
see the report totals by debits and credits.

 

[fredg]

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

=SUMIF(D3485,">0",(D3485))
=SUMIF(D3485,"<0",(D3485))

In my Access report "D3485" represent my field [Amount]. I am trying to
see the report totals by debits and credits.

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))

 

[JessicaMtgt]

Perfect - Thank you fredg!!!!!!

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

=SUMIF(D3485,">0",(D3485))
=SUMIF(D3485,"<0",(D3485))

In my Access report "D3485" represent my field [Amount]. I am trying to
see the report totals by debits and credits.

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))