Query to return group name with highest subtotal

[ONITAPGR]

Hi!



I'm running Access 2007...

I have a table "Table" with thousands of rows of with 3 columns...The Columns are Name, Location, and Amount

I have a query "Query" that is grouped by Name and Location, and sums Amount.

I want to create another query that gives Name and then within each Name, returns the Location in which the total summed amount is the highest...in other words, the "most popular" Location (in terms of total Amount) for every Name.

I attached an jpg file that describes what I am looking for...

Thank you for any help!

[June7]

Review this article http://office.microsoft.com/en-us/ac...010096437.aspx