FirstDistinct

When used within a query the function produces a recordset that contains only one record for each unique value of the argument. When used within a virtual field the function will return True for records that match the criteria given and False for records that do not.

FirstDistinct ( <table_name or expression>, <field> )

• table name or expression: Can be either a table name, or an expression (a query string or another query domain function) resulting in a recordset.

• field: Can be a fieldname or a virtual field expression.