Syntax
GROUPFIRST(<any>; order by any)
Description
This function returns a value in a group as specified by the ordered column's first value.
- If the column used to order the group is a number, then the value used from the order column is the lowest number.
- If the column used to order the group is a string, then the value used from the order column is the lowest number (in string form). If no numbers (in string form) are present, the first capital letter alphabetically is used. If no uppercase letters are present, the first lowercase letter alphabetically is used.
- If the column used to order the group is a date, then the value used from the order column is the earliest date.
...