counting values in a form

[chainedtodesk]

i have a screening tool (test) that uses several option groups (50) and each response is vauled 1-5. i need to be able to count the values of each question. show how many of the 50 were answered 1, how many were 2 etc. can this be done with form values? Thanks

 

[MajP]

I assume these are bound controls. Take a look at the "dcount". You can put this in an unbound control but you may have to refresh, recalc the control to ensure as you enter questions the control gets updated. Depending on where you want to use these values you may just want to make some queries to sum these values.

 

[TheAceMan1]

How are ya chainedtodesk . . .

[ol][li]Put 5 unbound textboxes in the header or footer of the form. Name the textboxes [blue]i1, i2, i3, i4, i5[/blue].[/li]
[li]In the [blue]Tag[/blue] property of each Option Group, enter a question mark [purple]?[/purple] (no quotations please).[/li]
[li]Add a [blue]Command Button[/blue] then copy/paste the following to the buttons [blue]On Click[/blue] event:

[blue]   Dim idx As Integer, ctl As Control
   
   Me!i1 = 0
   Me!i2 = 0
   Me!i3 = 0
   Me!i4 = 0
   Me!i5 = 0
   
   For Each ctl In Me.Controls
      If ctl.Tag = "?" Then
         idx = Nz(Me(ctl.Name), 0)
         
         If idx > 0 Then
            Me("i" & idx) = Me("i" & idx) + 1
         End If
      End If
   Next[/blue]

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

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[chainedtodesk]

thanks for the input, yes the fields are unbound and thats why i couldnt get dcount to work. i had used it previously in another application but couldnt make it work here so that answers that issue. thanks again MajP.

i will try the other suggestion supplied by TheAceMan1 since these are unbound, thanks TheAceMan1