Largest Value Query

[Lauren36]

I know that this is probably a very simple thing, but I need help writing a query that will find the largest numeric value in a field. Thankyou in advance for the help.

 

[mdthornton]

In the query design window click on view->totals. In the total box for the field you need select Max. All the other columns will be set to Group By by default. If you have other numerical columns you'll need to select something meaningful (min, sum, avg etc). Good Luck,
Mike T

 

[Lauren36]

When I did this it only put the values in ascending order and I only wanted the record with the maximum value. What am I doing wrong?

 

[mdthornton]

If you only want a single value then get rid of all the columns you don't need. If some of those columns have criteria change the total from group by to where.

Good Luck,
Mike T