I have a report with these THREE fields

Product, Date, Usage

For each Product I have listed out the usage and date of usage.

I have two grouping levels

1st - Product
2nd - Date

In the Product Footer, I have the MAX of Usage i.e. =MAX([Usage]).

How do I add the date that corresponds to the MAX usage number?

What happens if there is more than one date with usage the equals the MAX usage?

I'd apreaciate any help!
:confused:

EDIT: the report fields are from a query.

This might be helpfull but I haven't figured it out yet...
:(

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=44957
(From Guru Pat Hartman)