Number of values in a found set

[tomp]

Is there an elegant way to count the number of different values for a field in a found set?

I can think of using a calculation field that has the field value if in the found set, empty if not. Then defining a value list for that calc field and counting the items with a values function. But that seems rather cumbersome.

TIA

[Søren Dyhr]

I would make a subsummary report....

--sd

[tomp]

I can only see how to use sub-summaries to tell me how many records of each value I have in a found set. What I need is how many distinct values of the field there are in the found set.

For example, if I had a database of restaurant tickets with menu items ordered,how could I determine how many different tickets had a particular item on them?

tkt 1 item 1

tkt 1 item 2

tkt 2 item 2

tkt 2 item 2

tkt 3 item 1

If I did a find on 'item 2', there would be three records found. The number of values for 'ticket' in the found set is '2'. '2' is the number I need to get.

I don't see how sub-summaries will help me with that.

Am I missing something?

[comment]

See if this helps:

http://fmforums.com/forum/showtopic.php?tid/197861/

[tomp]

I downloaded the 'test' database from the previous thread and mimiced it.

It gives me what I need.

Thanks!