Matt said:
Ok, i understand the concept of the optin group, but what i REALLY nee
is to have 2-6 check boxes, with only one possible option, send data t
their own column in the table. for example.... YES is checked, and N
isnt, YES gets populated with a 1 (or whatever) while No gets a 0.
Conversly, if that situation is in effect, and someone clicks no, the
yes becomes unpopulated. I know that this can be achieved by using a
option group, but it really doesnt help me with the reports i am tryin
to write (Survey results) where i really need to count totals and hav
the data NOT affect the next column.
Any advise please help...i am NOT a programmer, but i got thrown unde
the bus on this project.
Thanks!
With an option group, you can have any number of options.
Put each of your 6 or 7 checkboxes in a group. When any one of them i
clicked, the OPTION_GROUP control has the value of the clicked checkbox
The option_group control always has the value of the currently checke
item.
If your group has three checkboxes for YES, NO, and MAYBE, and the
have values of 1, 2 and 3 respectively, then when you click MAYBE, th
option group's value becomes 3. WHen you click NO, it becomes 2. et
etc.
To translate this into your report, you simply need to have ALL th
values on the report default to ZERO, and then take the value of th
option group and apply it to the value of the item on your report.
In other words, your report has three checkboxes for YES, NO and MAYBE
and they are ALL SET TO FALSE - ALL OF THEM. It then takes the value o
the optiongroup and says "2... OK, set the value of the NO checkbox t
TRUE.
Since the remaining checkboxes remain FALSE, you have effectivel
transfered the ONE option from your option group to the ONE option yo
want to display on your report.
I bet that's just clear as mud, but I think you get what I mean
