Need to count number of unique entries

[ggh]

I need to count the number of unique entries in a given field. The field is a FileMaker serial number (alphanumeric). Any suggestions?

[LaRetta]

Hi ggh,

Create a Value List based upon the serial field (all values).

Create a calculation (number, unstored) with:

ValueCount(ValueListItems(Get(FileName) ; "thatVLname"))

LaRetta :wink2:

[krdzine1]

Hi ggh,

Create a Value List based upon the serial field (all values).

Create a calculation (number, unstored) with:

ValueCount(ValueListItems(Get(FileName) ; "thatVLname"))

LaRetta

I don't think I'm getting how you created this...

step 2 was to create a calculation field right... defined as the calculation you wrote right??? Am I missing something? I'm trying to modify your suggestion to count unique entries of a text field but how I put this in... I just get "0"

[LaRetta]

You must enter your specific value list name EXACTLY and surround it with quotes.

Yes, step 2 is a calculation field.

Otherwise, it should be working correctly. Can you post your exact syntax used? You can paste your calc right in this thread.

L

Edited October 31, 2005 by Guest

[ggh]

My apologies for not responding sooner. I did follow the steps without a hitch! Very elegant and quick. Thanks!