Count the times text shows

[ptrifile]

I have a form that has about 10 different combo boxes on it. There are 3 choices in each combobox (YES, NO, N/A). If i want a textbox on the form to show how many times "YES" was chosen on the form how could i accomplish this?

Thanks for any help!

Paul

 

[dhookom]

Add a text box in the form header or footer section with a control source like:

=Abs(Sum([Your Field Name Here]="YES"))

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

dhookom . . .

[blue]Nicely Done![/blue]

See Ya . . .

Be sure to see FAQ219-2884 Worthy Reading!
Also FAQ181-2886 Worthy Reading!

 

[missinglinq]

Isn't the OP saying that each record had 10 different combo boxes, and he wants to know, on a given record, how many of those 10 fields has 'Yes' selected? As opposed to how many records on the form has 'Yes' chosen for a single, given field? OR am I reading this wrong?

The Missinglinq

Richmond, Virginia

The Devil's in the Details!

 

[dhookom]

Good call. Let's wait to hear from the OP.

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

ptrifile . . .

[blue]missinglinq[/blue] has asked a good question. Either way here's a function to start off with. In form design view make sure you add a question mark [blue]?[/blue] (no quotations please) to the [blue]Tag[/blue] property of each combobox. Then copy/paste the function below to the forms code module.

[blue]Public Function YesCnt() As Long
   Dim ctl As Control, cnt As Long
   
   For Each ctl In Me.Controls
      If ctl.Tag = "?" And Nz(ctl, "") = "Yes" Then
         cnt = cnt + 1
      End If
   End If
   
   YesCnt = cnt

End Function[/blue]

Finally the [blue]control source[/blue] of the textbox becomes:

 = YesCnt()

[blue]Your Thoughts? . . .[/blue]

See Ya . . .

Be sure to see FAQ219-2884 Worthy Reading!
Also FAQ181-2886 Worthy Reading!