Get_IndexAndCount ( TableName ; FieldName ; RecordSeparator )
Uses SQL to return List of counts & unique values on a field
Average rating: 4.4 (12 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
PURPOSE: Determine count & unique values for a field
Uses SQL query, so is quite fast
If you use ¶ as the RecordSeparator, this creates a value list
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.