Need to count occurences of information in Query

[tjisaacs]

I have a query that returns data based on fields

country in range

the country field contains multiple countries, I want to make a report that counts the number of times the country appears

the in range field contains OK, out of range, not received

I also want to count the number of occurences of each of these and keep tied to the country

example
I would like a report that looks like this

Country Total # Out of range OK Not received

Argentina 6 2 2 2
Belgium 8 2 5 1
Brazil 2 1 1


Thank you

 

[nberryman]

Use the Report Wizard. Select the Query and folow the steps. You will be asked if you want to Group By fields, add the field there and check the Grouping Options button.

Next you will be asked for a Sort Order, check the Summary Options Button and the rest should be straight forward.

Let me know if you have any problems
Neil Berryman
IT Trainer
neil_berryman@btopenworld.com