Trouble with count query based on person's age entries, count of people from 1966, 1967, 1968, etc.

[rscott7706]

I searched the queries forum, and could not find n answer to my question. I am sure it is there somewhere, but finding it proved difficult.




I would like to create a query that lists a count of all fields by persons age. I have a table that lists all the ages of high school graduated classmates.


Sample (Count would be the result of the query):


Age Count
90 10
89 16
87 20

I tried to do a count query, but get wonky results. Here are two screen dumps (one works, the other does not):


I am somewhat of a "noobie" - love Access, but get little use time these days.

[ranman256]

you need 2 fields in the query
YEAR, and count(YEAR)

[CJ_London]

you also need to consider that age is not a good metric to store, otherwise next year guess what, you are going to have to go into each record and add 1 to the age. Better to store some other value such as date or year of birth so you can calculate the age