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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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?
 
Fast filter on a query (highlight the name and click on the lightning
icon)?

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math


Roger said:
Hi
I have a table with two columns; one with names and the other with
Click to expand...
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?
 
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.
 
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
 
I don't think you can do what your want, but this would not be the first
time I did not know how to do something in Access



--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math


Roger said:
Thanks for answering, but I do want age.
For an output, I'd like
Mike Joe
13 23
52 12
34 77
Or just the Mike column would do. I would like only to have the name
Click to expand...
once, while a list of all the ages for all the different Mike's underneath,
or in another column, it doesn't matter.
 
Back
Top