picking things out of a table without use a filter or query criterion

[Roger]

Hi
I have a table with two columns; one with names and the other with ages.There are recurring names but with different ages. (E.g. Mike, Mike, Mike; 13, 57, 22). I used a distinct query to pick out all the unique names (no repetition), but how do I pick out only the ages of the different Mike's without applying a filter, or using a query with the criteria box with the name Mike?
I just want the ages of the Mike's without having to type in the word Mike at all.
Thanks

 

[Shao]

Have you tried having a query only for Age? I am assuming
you only want age and don't care to reference it to the
names.

-----Original Message-----
Hi
I have a table with two columns; one with names and the

other with ages.There are recurring names but with
different ages. (E.g. Mike, Mike, Mike; 13, 57, 22). I
used a distinct query to pick out all the unique names (no
repetition), but how do I pick out only the ages of the
different Mike's without applying a filter, or using a
query with the criteria box with the name Mike?

 

[Roger]

Thanks for answering, but I do want age
For an output, I'd like
Mike Jo
13 2
52 1
34 7
Or just the Mike column would do. I would like only to have the name once, while a list of all the ages for all the different Mike's underneath, or in another column, it doesn't matter.

 

[Roger]

Hi, thanks for answering
Is it possible to choose the name without clicking on it? Or clicking it in a distinct query, and then fast filter it with another table