Access report totals

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
 
W

Wolfgang Kais

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