Set Criteria for Highest Value in a Field

G

Gordon Fisher

What is a simple way to set the criteria for a field to
return only the record(s) with the highest value? The
fields records are in currency format. I've tried to use
the function MAX, but can't get the syntax right.

Thanks for your help.

Gordon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Queiry to return highest value or number in a field 6
location of highest consecutive values 0
Finding location (or start cell) of highest consecutive values 3
ASK Field Formatting 1
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Finding largest total of ANY two values in a data set 6
SELECT MAX(value) from table1 and add several associated values from table2 10

Top