query to show the maximum value in a column

[Lifeseeker]

Hi,

I would like to run a query that shows a record having the highest value in one of its column. It's a numeric value.

Wonder what should the syntax be in the query.

any thought is much appreciated.

 

[John Big Booty]

Have a look at a GroupBy (total) Query, perhaps this article will give you some pointers.