To find/list all unique values in one or more columns, use the Tools > Find Unique Values command. In the displayed dialog box you can specify:

• whether to search for unique values within the entire table or the current record set,
• which record order is to be used for displaying: the physical table order or any sort order,
• up to 100 fields to be used as a duplicate/unique key,
• how to display the results:
  • the first (entered in the table) records from each group of duplicates,
  • the last (entered in the table) records from each group of duplicates,
• a numeric field where the frequencies (number of occurrences of found values) will be saved.