Question: what is dmax in access?
Answer: The DMax function returns the maximum value that satisfies criteria. If expr identifies numeric data, the DMax function returns numeric values. ... You can use the DMax function to specify criteria in the Criteria row of a query, in a calculated field expression in a query, or in the Update To row of an update query.