Count records in a report

[Angela]

Is there a function in Access that would enable me to count the records in a
Report when a check box is ticked

 

[phildenuh]

Is there a function in Access that would enable me to count the records in a
Report when a check box is ticked

if you have a query associated with this report , add a new column
call it say Count, then in the criteria put in Is Null, i think if you
do it this way it would work but you will need more grouping in your
report. Just add the field could to your report.

 

[Angela]

Thanks for this. I could do this, the trouble is, the report has been set up
by someone else, and there are 2 check boxes to be counted for each record

A

 

[John Spencer]

Since checkboxes are usually tied to a yes/no field they always have a
value. The trick here is to account for the field always having a value (-1
or 0).

=Abs(Sum(CheckboxField))

or

= Count(IIF(CheckboxField=True,1, Null))



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Angela]

Many, many thanks

Since checkboxes are usually tied to a yes/no field they always have a
value. The trick here is to account for the field always having a value (-1
or 0).

=Abs(Sum(CheckboxField))

or

= Count(IIF(CheckboxField=True,1, Null))



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..