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 (AT) g43g2000cwa (DOT) googlegroups.com>,
marshachristy (AT) gmail (DOT) com wrote:

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)