You have a table tblMainTable: MTID, SomeInfo, CaseID, Win, ..., where Win has values e.g. 0 and 1, which represent False/No and True/Yes;
You have a table tblCases: CaseID, CaseText;
On form fMainForm you have along with other possible fields combo boxes cbbCase with ControlSource = CaseID, RowSourceType = "Table/Query", RowSource = "SELECT * FROM tblChoices" , BoundColumn = 1, ColumnCount = 2 and ColumnWidths = "0;2.5" (you see CaseText, CaseID is selected), and cbbWin with ControlSource = Win, RowSourceType = "Value List", RowSource = "1;Yes;2;No", BoundColumn = 1, ColumnCount = 2 and ColumnWidths = "0;2.5".
The query to count cases will be something like (on fly, you have to check the syntax yourself):
Code:
SELECT c.CaseText, COUNT(mt.CaseID) AS [CaseCnt] FROM tblMainTable mt LEFT JOIN tblCases c ON c.CaseID = mt.CaseID GROUP BY c.CaseText
To count Win:
Code:
SELECT Iif(mt.Win=1,"Yes","No") AS [Win], COUNT(Nz(mt.Win,2)) AS [WinCnt] FROM tblMainTable mt GROUP BY Iif(mt.Win=1,"Yes","No")
(when Win is not determined, then there is no win)