Grouping and Summing Query Results

speed11ca

New member
Local time
Yesterday, 16:04
Joined
Nov 25, 2009
Messages
1
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
 
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.
 
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:
sigma.png
 
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.
 

Users who are viewing this thread

Back
Top Bottom