Group By in a Query

[cunningham93]

Hello, I'm having trouble using the "group by" function in my query. The option in design view is not showing up and I'm not able to figure out what I'm doing wrong. What is there in design view is Field, Table, Sort, Show, Criteria, Or. I seem to be missing the "Totals" option. I'm sure I'm doing something simple wrong. Any help with be great!
Thank you!

 

[pr2-eugin]

You have to make the Query a Totals query, this will normally be on the Query Design tab. The Summation symbol.

http://office.microsoft.com/en-gb/access-help/count-data-by-using-a-query-HA010096311.aspx#BM3

 

[cunningham93]

Thank you for your help! I haven't been using Access for a while so I forgot the simple things.
Thanks!