This function returns the largest value in the given table's column which complies with the specified condition.
DMAX([Table or Table Name],[Column Index],[Condition])
Table or Table Name is the table to search in
Column Index is a number representing the index of the column in the table
Condition is the condition to test each cell in the column with
|DMAX(DwLookupDataTable,1,">10")||This will look in the table DataTable, in column 1 and return the largest value that is less than 10.|