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

Adding Min and Max buttons on a form 4
MAX and Min value 2
Function for 2nd and third low or Max 2
Form Properties 1
Compare Min and Max value of a field 3
Complicated vlookup/min-max query...please help 6
locating the cell that contains the MIN or MAX 1
Average (exclude 1 min & 1 max Value) 2

Top