SQL MAX() Function
Selecting MAX() of a column returns the largest value in that column in a single record. If the table has no records, MAX() returns a single record of value NULL rather than a zero record result. As a result you must test for NULL in any case where it is possible for the table to have no records to prevent runtime errors, but you don’t need to test for EOF because you will always get a record back from the query.
A number of other functions should behave similarly.