Hi there,

Can someone please tell me how to do this.

I have fields that are either checkboxes, drop-down value lists, or
radio buttons,

I want to be able to calculate the number of records that have a
certain value from these fields. For example, if I have a value list
that has say One, Two, Three in it, I want to see  the total number of
records that has one, the total with two etc. Also, if I have a
checkbox, I want to see how many records has each option.

I need to get this info in order to do a report summarizing different
things.

Can someone please tell me how to do this? 

Thanks a lot,

Chris

You need a utility table for this where you create 1 record per value
list item.
Create a link from the value list item field in the utility table to
the actual field that uses that value list in your database.
Create a calc field in the utility table that counts the related
records.

In article <1130195354.445166.201660@g43g2000cwa.googlegroups.com>,
marshachristy@gmail.com wrote:

> Hi there,
> 
> Can someone please tell me how to do this.
> 
> I have fields that are either checkboxes, drop-down value lists, or
> radio buttons,
> 
> I want to be able to calculate the number of records that have a
> certain value from these fields. For example, if I have a value list
> that has say One, Two, Three in it, I want to see  the total number of
> records that has one, the total with two etc. Also, if I have a
> checkbox, I want to see how many records has each option.
> 
> I need to get this info in order to do a report summarizing different
> things.
> 
> Can someone please tell me how to do this? 

It depends on exactly what you're wanting to do with the totals and how
you're doing the summarizing.

FP has given you one method using a separate file and relationship link.

Another method is to use a set of Calculation fields.
eg.
        Option_Is_One   = If (Option = "One", 1, 0)
        Option_Is_Two   = If (Option = "Two", 1, 0)
        Option_Is_Three = If (Option = "Three", 1, 0)
      etc.

You can then use a summary field or self-relationship to the same table
/ file to simply Sum these fields.


Helpful Harry                   
Hopefully helping harassed humans happily handle handiwork hardships  ;o)