Display the record ID of the top or bottom value in a field (1 Viewer)

Access_Help

Registered User.
Local time
Today, 02:55
Joined
Feb 12, 2005
Messages
136
Hello,

I would like to display the ID of the member with the highest sales and the member with the lowest sales in the report footer as a calculated field.

Is there a method to achieve this?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:55
Joined
May 7, 2009
Messages
19,169
use DMax() and DMin() functions.
 

jdraw

Super Moderator
Staff member
Local time
Today, 05:55
Joined
Jan 23, 2006
Messages
15,361
Research DMax and DMin for examples
 

Users who are viewing this thread

Top Bottom