Total in a query

[netrusher]

I have a table. The table stores a workers name and information such as Primary Station Verified.
The Primary Station Verified is a yes/no checkbox. It also has the dates that each worker is verified.

I want to do a query that will show me the total number of people and out of that total number of
people how many are verified. Then I will turn that data into a graph.

How do I do the Query to show me (example) There are 50 people and (example) 25 of them are
verified? I know how to do the query to show all of the people and who are verified but I just want
the numbers.

 

[lupins46]

Start a new query based on your table.
Add the name field to the grid; add another field to the grid which is:
Ver:Abs([Primary Station Verified])

If you view this query you should just a list of names with a 1 if they bare verified and a 0 if they are not.
Back in design view change the query to a Totals query using the toolbar button.
Chnage the 'GroupBy' to 'Count' for the name column and set the second column to 'Sum'.
You should now get the totals you want.