question about select distinct and ms access

[laFiera]

I have a table with 3 columns, indexNumber, field2,field3

I want to return all the distinct values in field 2. Simple enough
select distinct field2 from tablename

However, since there are 200,000+ records, I want to know what the indexnumber for those values are for field2

So i thought
select distinct field2, indexnumber from tablename

but that returns something similar as if i would have typed select distinct frield2 and select indexnumber from the table....
any ideas if this type of query can be done in access?
thanks!