D Darrell Jul 30, 2004 #1 How would one go about selecting the NEXT-to-the-last (or max, or min) value in a sorted field? Thanks!
How would one go about selecting the NEXT-to-the-last (or max, or min) value in a sorted field? Thanks!
F fredg Jul 30, 2004 #2 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"))
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 Jul 30, 2004 #3 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...
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...
