For example, the pattern ?
will match strings with 3 exactly characters in more modern functions, but not in the database functions.
If you are using wildcards, test carefully.
Multi-row criteria
The criteria range for DMAX can include more than one row below the headers.
When a field is provided DCOUNT will only count numeric values in the field.
UseDCOUNTAto count numbers or text values in a given field.
Use the MAX function to get the maximum value.
