W
Wolfman311
I have a form with an unbound text box. The form also has about 50 fields
that coorespond to answers from a survey. All 50 have the same 4 options to
choose from (Correct, Incorrect, Reversed and NA) The unbound text box
contains the concatination of all 50 fields separated by a space. At the
bottom of the form I need to add 4 additional unbound text boxes that each
coorespond to 1 of the 4 possible answer...ie a count of the number of times
"correct" is in the string and have that number displayed in the field...
likewise a count of the number of the other 3 options each displaying in
their own box so that at a glance as we scroll through the records we can see
the number of corrects/incorrects etc that each respondent had...I've seen
lots of posts here about different methods of counting characters but nothing
quite like what I've described.
Or if there is a better way to count the responses other than dumping them
all together I'm game. I was trying to avoid going into each control's event
and coding, that is the only reason I chose to combine the values of all
fields into one string...but I'm stuck frome there.
Can anyone help? I'm using Access 2003.
Thanks,
that coorespond to answers from a survey. All 50 have the same 4 options to
choose from (Correct, Incorrect, Reversed and NA) The unbound text box
contains the concatination of all 50 fields separated by a space. At the
bottom of the form I need to add 4 additional unbound text boxes that each
coorespond to 1 of the 4 possible answer...ie a count of the number of times
"correct" is in the string and have that number displayed in the field...
likewise a count of the number of the other 3 options each displaying in
their own box so that at a glance as we scroll through the records we can see
the number of corrects/incorrects etc that each respondent had...I've seen
lots of posts here about different methods of counting characters but nothing
quite like what I've described.
Or if there is a better way to count the responses other than dumping them
all together I'm game. I was trying to avoid going into each control's event
and coding, that is the only reason I chose to combine the values of all
fields into one string...but I'm stuck frome there.
Can anyone help? I'm using Access 2003.
Thanks,