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

[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

 

[gumby]

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

 

[gumby]

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.

 

[Guest]

You can do this in one query
SELECT Count(YourTableName.CourseName) AS CountOfCourseName, State
FROM YourTableName
WHERE ((YourTableName.Played) =True)
GROUP BY YourTableName.State

 

[David Cox]

didn't the sum query give - [the right answer] ?