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...
 
Top