Access report totals

  • Thread starter Thread starter coyoteservices
  • Start date Start date
C

coyoteservices

I have a report that shows all invoices sent in the current month. I
use an on format event to change the colour of each detail line to show
if the invoice has been paid or not.

Paid is shown as a true or false checkbox.

I also have a total at the bottom of the report showing how much has
been invoiced in the month.

What I would like to do, is show on the bottom of the report two more
totals, one for paid and one for unpaid.

Any help will be appreciated.


Thanks


Mat
 
Hi Mat.
I have a report that shows all invoices sent in the current month. I
use an on format event to change the colour of each detail line to
show if the invoice has been paid or not.

Paid is shown as a true or false checkbox.

I also have a total at the bottom of the report showing how much
has been invoiced in the month.

What I would like to do, is show on the bottom of the report two more
totals, one for paid and one for unpaid.
Click to expand...

In the report footer, add a textbox with controlsource:
=Sum(Iif([Paid],1,0))
and another textbox with
=Sum(Iif([Paid],0,1))

(Assuming that [Paid] is a field of the recordsource of the report.)
 
Back
Top