Hi All,

I have a table containing two fields, Item and Qty. Neither field is uniue. I need to select the distinct list of items from the table, and any one of the 'associated quantities'. Eg:

Item Qty
A 2
A 4
A 6
B 3
C 7
C 9

Results I want are:

A 2 (or 4 or 6)
B 3
C 7 (or 9)

Thanks,
Rob