Control Souse for Text Box

  • Thread starter Thread starter CEV
  • Start date Start date
C

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
 
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
Click to expand...

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)
 
Thanks Fred!!

fredg said:
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
Click to expand...

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)
Click to expand...
 
Back
Top