Calculating yes/no fields

[jlg5454]

Hi,

I have about 20 yes/no check box fields that I need for calculating an average for a field called score. If each check box is checked it is assigned 10pts els 0 points. Is there any example out there I can follow. I keep coming up with errors in the score field.

Thanks for any help.

 

[Remou]

What have you tried?

 

[TheAceMan1]

How are ya jlg5454 . . .

The following will return the number of checked boxes in the current record.

Note: for each checkbox of interest add a question mark [purple]?[/purple] to its [blue]Tag[/blue] property!

[blue]Public Function ChkCnt() As Integer
   Dim ctl As Control
   
   For Each ctl In Me.Controls
      If ctl.Tag = "[b]?[/b]" Then ChkCnt = ChkCnt - Nz(ctl)
   Next
   
End Function[/blue]

[blue]Your Thoughts! . . .[/blue]

See Ya! . . . . . .

 

[Remou]

Twenty checkboxes implies that there may be some normalization issues. It may be as well to examines these, before other problems arise.

 

[jlg5454]

Thanks for the replies. I'll give them a try