We have a bunch of clients. For each client there is more than one matter linked to that client. I need to find the matter for each client that has THE MOST time logged against it. I was thinking I should use the Totals functions to do this. I tried using the "MAX" function on the time and the "Last" and "First" functions. I still see the same client with several matters showing in the query results when I use these functions. I need ONE client with the ONE matter that has the most time against it.

Any ideas??

Thanks!!