Query of 2 different values for same field?

[cotec]

I have a database table with a boolean field for whether a user finishes a module. I then want to query how many times a student was able to finish a module and how many times a student wasn't able to finish. Since the sum of these two numbers is not always the same, I can't simply subtract one value from a known number to get the other value.

So, is it possible to have a query where I request the count of the records where this field is true and where this field is false rather than performing 2 queries?

Chris

[schizo]

your sql statememt would look something like...
SELECT COUNT(idColumn) AS varCount FROM someTable WHERE someVar = 'true'

then access varCount inside the recordset return