Display the record ID of the top or bottom value in a field

[Access_Help]

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]

use DMax() and DMin() functions.

 

[jdraw]

Research DMax and DMin for examples