Count Unique?

Because of the way one of my databases was designed, it can produce several rows that have all the same data except for one column (i.e. 5 rows with 101 for the "entry ID" but another column shows various data for a field). How do I count the unique number of "entry IDs?" I only want to know the number of unique entries for the column that is showing repeats such as the "entry ID" column.

I hope that made sense...

Hi @paintbb84
You can use the Custom Expression function Distinct([column])

1 Like