MS Access Max() Function
The Max() function in MS Access is used to find the largest value within a set of numbers. It's a very common aggregate function used to summarize numerical data.
Max(): Definition and Usage
Max() is helpful for identifying the highest value in a column or the result of a calculation. It's frequently used to find the maximum price, quantity, or any other numeric value in your data.
Related Function
The Min() function finds the smallest value, as opposed to Max() which finds the largest.
Syntax
Syntax
Max(expression)
Parameter Values
| Parameter | Description |
|---|---|
expression |
A numeric field name or a formula that results in a numeric value. This is required. |
Example
Finding the Maximum Price
This example finds the highest price among products in the 'Products' table (assuming a table named 'Products' exists with a 'Price' column).
Syntax
SELECT Max(Price) AS LargestPrice FROM Products;
Output
LargestPrice
------------
99.99 (Example output; this will vary based on your data)