help with count

[Bonzay0]

Hi, I want to make a query that count by the inside of a table
ex:
i have the table Reviews inside is like this:

I want that the query will give me this count:
555555443 Bad: 1
53 OK: 1
53 Good: 1
856 Good: 1
853 Exc: 1
and so on (if there are others)

can it be done by a query? if so how? if not how can i do it and where? (module/macro...)

Thanks in advance

 

[Mike375]

Make a query based on the table and drag the field Review_Level down to the query grid.

On the toolbar you will see the symbol Sigma (I think that is what it's called) looks like an E and click it. That will make GroupBy appear under the field Review_Level

Now drag Review_Level to the next column and you will see GroupBy appear. On GroupBy you will get a drop down list. Select Count. Save query and open.

You will see two fileds, Review_Level and CountOfReview_Level.

 

[Bonzay0]

i cant believe i didnt try that

thank you for the help

 

[Mike375]

I think you changed your post as I posted so might be no longer relevant.