To find/list field values from a given quartile or below/above the mean value, use the Tools > Find Quartiles / Mean command. In the displayed dialog box you can specify:

• whether to search the entire table or the current record set,
• whether the quartile/mean values used as the search threshold should be calculated from the entire table column, or only from the column values in the current (already filtered) record set.

Note: for non-numeric fields the statistics are obtained as follows:

• string lengths for unformatted Text fields,
• numeric date/time values for Text fields formatted as Date/Time,
• the total size in bytes for Long Text and Images/Files fields.