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.