NEXT TO Last (or Max or Min)

D

Darrell

How would one go about selecting the NEXT-to-the-last (or
max, or min) value in a sorted field?

Thanks!
 
F

fredg

How would one go about selecting the NEXT-to-the-last (or
max, or min) value in a sorted field?

Thanks!
Click to expand...

This works for me.

DMax("[ANumber]","YourTable","[ANumber] < " &
DMax("[ANumber]","YourTable"))

DMin("[ANumber]","YourTable","[ANumber] > " &
DMin("[ANumber]","YourTable"))
 
D

Darrell

Thanks Fred! That looks logical.
-----Original Message-----
How would one go about selecting the NEXT-to-the-last (or
max, or min) value in a sorted field?

Thanks!
Click to expand...

This works for me.

DMax("[ANumber]","YourTable","[ANumber] < " &
DMax("[ANumber]","YourTable"))

DMin("[ANumber]","YourTable","[ANumber] > " &
DMin("[ANumber]","YourTable"))
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 

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

MAX and Min value 2
=min =max 1
Help with time function 7
Statusbar cell values? 5
Adding Min and Max buttons on a form 4
Conditional Formating: MAX & MIN 3
Combining two formulas 0
Macro to determine min/max values of column 3

Top