Re: Group and Count

OK, got the Group By to be in my design view but I'm confused as to how to
get it to "group" numbers. My database is something like this:

name state zip code
my table my table my table
Group By Group By Group By

I only want to group zip codes and then count the number in each group. Do
I have to build some kind of expression in here?

"bcap" wrote:

The button is on the toolbar, it's got a Greek "sigma" on it (looks like a
bent capital "E").

You can also choose "Totals" from the View menu.

"Cindy" <Cindy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AA6AAECE-6DC3-4243-8B66-7FBE0764E655@xxxxxxxxxxxxxxxx
I have a query with a list of participants including their zip codes. I
need
to group by zip code then count the number of rows per group. I'm not
sure I
can even figure this out, since I can't seem to locate the "Group" button
or
area. I have looked in all of my toolbars and have right clicked within
the
query in the design view. Where else would it be located? Thank you.



.