I am using a SQL statement to populate a MSFlexgrid, but I find that I am getting the wrong results I want to select and group and count all records by a field (clm_det_r) where one field ( chkConfirmed_r) is true. Instead, it is pulling all records where clm_det_r is not null.

This is the code I've written:
VB Code:
  1. CatSQL = "SELECT [page2_3].[clm_det_r], COUNT([page2_3].[clm_det_r])FROM [Page2_3]GROUP BY [page2_3].[clm_det_r] WHERE [chkconfirmed_r] = TRUE"
What am I doing wrong?