Selecting hihest instance in a tbl

[Ciaran]

Hey,
I’ve got a tbl with non-unique IDs and type.
I want to query the tbl for one instance of each ID and the highest type.
So looking at the tbl below
ID Type


A 1
A 2
B 2
B 3

I want to return the data below only
ID Type
A 1
B 2

Can anyone help me?
Regards,
C

[June7]

Try an aggregate GROUP BY (TOTALS) query. Use the Query Designer.

So the lowest number is the highest type?

SELECT ID, Min([Type]) AS Highest FROM tablename;

[Ciaran]

Thanks this helps