Collecting attributes of a field...

[#1]

Hi,

I have a question:  I'm trying to count the number of distinct values and the number of duplicates within a field within a straight table.  I thought that the expression "COUNT([DISTINCT]field_name)" would count the number of distinct values, but I didn't get a result when I reloaded the data. Nor did I get a result for counting the duplicates within a field as well.

So as an example, if FIELD1 contains the following values:

2

2

3

4

5

5

6

6

then I should have 5 distinct values (2,3,4,5, and 6) and 3 duplicates (3, 5, and 6).

Any help is appreciated.

Thanks,

Torino

[#2]

That's it!  I just made it more complicated, thinking there was some singular function that could do that.  Thanks for the help!.