Summary Reports - Check Boxes with value list 
Author Message
 Summary Reports - Check Boxes with value list

I have a text field called <options> in a FM Pro 5.0v3 database. On the data
entry layout this field is formatted to use a value list with 10 options,
displayed as check boxes. I have created a summary report to report on how
many options are ticked for a particular found set, using a summary field
<total_options> which is a count of <options>.

The report works fine when only one value is selected in the check boxes -
then the numbers are correct. However when a record has more than one value
selected in the check box it seems to only pick up one value rather than
counting all values, thus producing misleadings figures on the summary
report. For example, it might report that there were 33 people who had
selected option 3, whereas there were 39 in total if you do a find on that
option.

Does anybody know if you can produce accurate summary reports based on
multiple values in a check box field?

Many thanks in advance - Andrew



Tue, 19 Aug 2003 08:41:20 GMT
 Summary Reports - Check Boxes with value list

You could create a calc field which counts the values in the check box
field using the Pattern Count function with the return character as the
search string.  If there is only one value in the field, there should be
no returns.  If there are two characters, only one return, so make
allowances for that.  Then reference the calc field in the summary
function calculation.

--
Bridget Eley


Quote:

> I have a text field called <options> in a FM Pro 5.0v3 database. On the data
> entry layout this field is formatted to use a value list with 10 options,
> displayed as check boxes. I have created a summary report to report on how
> many options are ticked for a particular found set, using a summary field
> <total_options> which is a count of <options>.

> The report works fine when only one value is selected in the check boxes -
> then the numbers are correct. However when a record has more than one value
> selected in the check box it seems to only pick up one value rather than
> counting all values, thus producing misleadings figures on the summary
> report. For example, it might report that there were 33 people who had
> selected option 3, whereas there were 39 in total if you do a find on that
> option.

> Does anybody know if you can produce accurate summary reports based on
> multiple values in a check box field?

> Many thanks in advance - Andrew



Tue, 19 Aug 2003 09:21:59 GMT
 Summary Reports - Check Boxes with value list

Quote:

> I have a text field called <options> in a FM Pro 5.0v3 database. On the data
> entry layout this field is formatted to use a value list with 10 options,
> displayed as check boxes. I have created a summary report to report on how
> many options are ticked for a particular found set, using a summary field
> <total_options> which is a count of <options>.

> The report works fine when only one value is selected in the check boxes -
> then the numbers are correct. However when a record has more than one value
> selected in the check box it seems to only pick up one value rather than
> counting all values, thus producing misleadings figures on the summary
> report. For example, it might report that there were 33 people who had
> selected option 3, whereas there were 39 in total if you do a find on that
> option.

> Does anybody know if you can produce accurate summary reports based on
> multiple values in a check box field?

As far as I know this can't be done in this way. First, you can't sort a
checkbox field accurately because what's in the field depends on the
order in which the checkboxes were clicked. Next, you can't summarise
multiple values from the same field.
Think of it this way. You have a pile of cards, one for each person.
John has 1 and 3 on his card. Mary has1, 3 and 5.
Sort these two cards so that two of the cards are in in the 1 pile, two
of the cards are in the 3 pile, and one in the 5 pile. You have only 2
cards, so it can't be done. This is how subsummaries work.

Anyway, your Options field will sort according to what's in it, and that
depends on the order in which the checkboxes were checked, and how many
were checked, so it's not going to work. For instance, if option 1 is
checked in one record and 1 and 2 and checked in the next, these will
have separate summaries as they are different items. If the 2 was
checked before the 1, that record will appear with other 2,1 items.

If all you want is to show is how many people chose each option, you can
do it another way. You will not, however, be able to show *which* people
chose each option. For this sort of thing I think you would need to use
a related file.

If you just want to show how many of each option was chosen, create a
calc field like this for each option
PatternCount(Options; "1")
or whatever the text is in option1, and so on for each option. This will
calculate 1 if that option is checked, zero if not.
Now create 10 summary type fields which total each of the new calc
fields. These will contain the correct totals.
--
Maire Black



Tue, 19 Aug 2003 20:46:30 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. One value in a check box value list

2. value lists and check boxes, automatically changing values

3. CDML: repeating check boxes from a value list

4. printing from results of check box value list

5. : FMP4 summaries of checked box fields

6. Application Role w/Access 2000 combo boxes, list boxes, reports

7. Toggling Between List Boxes at the Same Location and Selecting Records in Each List Box

8. list box 2 based on list box 1

9. summary field and value list

10. Q: Summary of db records by value list?

11. Getting Index from a List View check box

12. VB416 -- List of check boxes?


 
Powered by phpBB® Forum Software