Control Souse for Text Box

[CEV]

I have created a report that shows a check box for the records that show up
on the report. I added a text box and want this text box to show me the
total of how many check boxes are checked.

I entered the following but it does not work:

=Sum(Abs([Student]="1"))

I also tried leaving out the Abs but that also does not work. How should I
enter this?

Thanks,

Chad

 

[fredg]

I have created a report that shows a check box for the records that show up
on the report. I added a text box and want this text box to show me the
total of how many check boxes are checked.

I entered the following but it does not work:

=Sum(Abs([Student]="1"))

I also tried leaving out the Abs but that also does not work. How should I
enter this?

Thanks,

Chad

If [Student] is a check box field, then it's value is either 0
(unchecked) or -1 (checked).

To count checked boxes:

=ABS(Sum([Student]))

To count unchecked boxes:
=Sum([Student]+1)

 

[CEV]

Thanks Fred!!

I have created a report that shows a check box for the records that show
up
on the report. I added a text box and want this text box to show me the
total of how many check boxes are checked.

I entered the following but it does not work:

=Sum(Abs([Student]="1"))

I also tried leaving out the Abs but that also does not work. How should
I
enter this?

Thanks,

Chad

If [Student] is a check box field, then it's value is either 0
(unchecked) or -1 (checked).

To count checked boxes:

=ABS(Sum([Student]))

To count unchecked boxes:
=Sum([Student]+1)