Maintaining an associated variable when grouping

[richaccessuser]

I have an issue using hte Simple Query Wizard in Access.

I am attempting to Group by the field 'HouseName' and to group by the Max 'Area'. However I also want to retrieve from the query the County which is associated with this.
I have included a sample table below. I wish for my output table to be as follows;

HouseName: County: Area:
Park 1 A 100
Park 2 C 78
Park 3 A 70

(Where Park 1 is HouseName attribute, A is County attribute and 100 is Area attribute)



Sample Input Table:

HouseName: County: Area:
Park 1 A 100
Park 1 B 60
Park 1 A 85
Park 2 C 78
Park 2 D 34
Park 3 A 70

In SQL View my query looks like this;

SELECT TableExample.[HouseName], Max(TableExample.Area) AS MaxOfArea
FROM TableExample
GROUP BY Table.[HouseName];

I would greatly appreciate if someone could help me in recommending how to link the associated County to the output.

[pbaldy]

How about:

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