3 Replies Latest reply on Dec 9, 2013 12:25 PM by JoanneVermulm

    How to count the number of unique occurences in field.

    jenh

      Title

      How to count the number of unique occurences in field.

      Post

      Hello,

      I have a DB that has Serial No. as a field.  

      I need to count the number of times a Serial No. occurs. 

      Sometimes a Serial No is listed up to 4 or 5 times.  I only want to count it once.  

      I don't think value list will work since I will never know what the values could be and there hundreds.  There are always new values (Serial numbers being added)

       

      For example the field could have list of values such as;

      goats

      cow

      cow

      cow

      bird

      dog

      total count is 6, and count of unique values is 4.  

       

      Thank you.