Counting fields with SQL 1

[SpyPnch]

I have a table that has a check field and a field that has one of two entries. I would like to count the number of each entry minus the total number of check marks. How would I do in SQL?

 

[Remou]

Perhaps:

SELECT t.X, 
  Count(t.X) AS CountX, 
  Count(t.x)-DSum("Abs(ChkX)","t") AS [CountX-ChkX]
FROM t
GROUP BY t.X

Where X is the field, ChkX is the check field and t is the table.