Query of 2 different values for same field?
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?
your sql statememt would look something like...
SELECT COUNT(idColumn) AS varCount FROM someTable WHERE someVar = 'true'
then access varCount inside the recordset return
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)