AnsweredAssumed Answered

How to count the number of unique occurences in field.

Question asked by jenh on Aug 24, 2010
Latest reply on Dec 9, 2013 by JoanneVermulm

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.

 

 

 

 

Outcomes