Grouping and Summing Query Results

[speed11ca]

My query so far takes all the users date of birth and turns it into a column called calculated age.

I cant seem to figure out how to then group all the values less then 1 , =1, =2, etc.

Is it possible to have a query group and then sum results this information?

Thanks for any help you can provide

 

[John Big Booty]

Whilst the query is in design view click on the Group By button, that's the on with the Greek letter Sigma (Σ) on it. This will then give you whole lot of additional options for grouping, counting summing etc.

 

[boblarson]

Whilst the query is in design view click on the Group By button, that's the on with the Greek letter Sigma (Σ) on it. This will then give you whole lot of additional options for grouping, counting summing etc.

And a visual:

 

[giovaanni]

Create a column called Count and give it a value of 1. Then turn grouping on, group by your calculated age column and summarize by the count column. This will give you the total count of members for each age group.