How to count the number of unique occurences in field.
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;
total count is 6, and count of unique values is 4.