Totals Query of MAX with Corresponding Values

[aussie92]

Hello all... I feel like this is a fairly simple task, but for the life of me I cannot figure it out...



I have facility numbers that can correspond to several different types. Each of these types has a measurement of area (number; [AreaQTY]). They are all in one table. I would love to break them out into different, cascading tables (one for facility, one for type), but am not allowed at this point.

Assuming the information is all in one table, I want to get the type of facility for the largest area.

I am doing a totals query now with MAX AreaQty, but I cannot figure out how to just add the type without having it split it into groups. I just want to return the type per the largest area per each facility.

I also tried doing a DLookup on the MAXOfAreaQTY, but I need to link this with Excel and I cannot use a Dlookup or an Elookup when linking to excel....

Thoughts? Thanks!

[pbaldy]

Is this what you're after?

http://www.baldyweb.com/LastValue.htm