Hi,

How would you manage counting the frequency of all values in a field within a table?

For instance, there are 10 records in Table1. Field1 in Table1 has the following values:

Empty, 2, 4, Empty, 3, 1, 4, 4, 1, 4

The information I need would be:

Empty = 2 times

1 = 2 times

2 = 1 time

3 = 1 time

4 = 4 times

I guess this can be handled by a self cartesian relationship but I do not want to create more than one relationship or several different calculated fields. Field1 values are not part of a list: they could be any numeric value, included zero or even the field could be empty).

Thanks in advance

I do not want to create more than one relationship or several different calculated fields

What do you want then? Subsummary reports seems to fit the bill then, if a single summary doesn't count as calculated field in plural - unfortunately are the semantics a little diffuse here?

However do I usually solve such a problem in the vicinity of this:

http://fmforums.com/forum/showpost.php?post/266487/

--sd