Count 1,2,3 yeeeha

[trackmedic]

Ok,

first off, I know I ask alot of questions, but you guys always help me out. This is my issue. I have a query that list items in a "concerns" block.

when this query runs, it works fine. There are multiple returns, for example I have housekeeping return 7 times and I have safety return 4 times.

this occurs due to multiple entries of said returns.

what I would like to do is either create a query that counts this stuff or a report that shows how many of each item. The report would be better. I do not know where to start.

Thanks in advance!

 

[rainman89]

you mean a count of how many times something shows up?

just do a totals query and select count as the total should return 7 and 4 respectively

 

[trackmedic]

did not work

I did that and all it gives me is a bunch of 1's and 0's. i have attached a XL spread with what I have. I would like this to add up how many of each with the names of what its adding.

the yellow column is what I need to add up and possibly report as a graph.....!