How Do I Countn the # of "True" in a True/False Field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with three fields.

1. State
2. CourseName
2. Played

Played is the true/false field.

I need to create a query that will count the number of courses played by
state.

Any ideas? I've tried the Sum and Count features to no avail.

-Adam
 
Create a select qry first to get all the true values, and then a total
qty to count played and group by state.
 
Create a select qry first to get all the true values, and then a total
qry to count played and group by state.

base the second qry off of the first one.
 
You can do this in one query
SELECT Count(YourTableName.CourseName) AS CountOfCourseName, State
FROM YourTableName
WHERE ((YourTableName.Played) =True)
GROUP BY YourTableName.State
 
Back
Top