Access report totals

[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

 

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

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

 

[coyoteservices]

Fantastic,


Thanks very much

Mat