counting unique fields

[Aussie John]

Hi - seems simple but not having any success. I need to get the total number of same type fields.

eg

peter

john

fred

john

peter

=3 (ie john + fred + peter).

Help much appreciated & thanks

Edited December 1, 2009 by Guest

[bruceR]

Your question makes no sense.

You're talking about multiple fields; but you describe multiple values - and we don't know whether they come from multiple fields or not.

[comment]

Perhaps this is what you're looking for:

http://fmforums.com/forum/showtopic.php?tid/196904/#297916

Another option is to define a value list based on the field and count the values in ValueListItems().

[Aussie John]

Comment - brilliant!!