How to use the Min and Max Functions in Access 2000?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everybody

I am brand new in Access. I want to create a query to find the lowest and
highest values in a field, using the Expression Builder feature. I found out
that the Max and Min are in the Built-In Functions folder, but I have not
been successful in using them. I will appreciate anybody's help.

Thanks
 
Min and Max can only be used in SQL statements.

To find the minimum value for a particular field, your SQL would look like:

SELECT Min(MyField) AS Smallest FROM MyTable

If you're doing this through the graphical query builder, change the query
into a Totals query (either click on the Sigma button on the button bar, or
select Totals from the View menu). That adds a new row in the query grid
labelled "Total". Underneath the field in question, change the Group By that
appears by default to Min.
 
Back
Top