How do I count gender if a checkbox in another field of a table is checked in access

[macmiller6578]

Hi currently I am working on trying to count whether a particular tutor is male or female. I have a table that has gender information and I want to count when a checkbox is checked saying they are an active tutor in a query. I'm very new with this stuff so bear with me...this is my code currently->

MaleTutor: 
(select IIf(Tbl_TutorInfo.[Tutor Status]=True
   , (Count(IIf([Gender]=”Male”,0)) 
from  (select [Gender] 
   from tbl_tutorinfo inner join  tbl_tutorplace 
      on [Tbl_TutorPlace].[Tutor]= [Tbl_TutorInfo].[Tutor] 
   where (isnull([end date]) 
         or [end date] >=[forms]![mnu reports]![semestercut]) 
         and year = [Forms]![Mnu Reports]![Year] 
         and semester =[forms]![mnu reports]![semester])),0))

[Seth Schrock]

It looks like you are trying to do this via a query. Try the following query:

SELECT [Gender], Count(tbl_tutorinfo.Tutor) As TutorCount 
FROM tbl_tutorinfo inner join tbl_tutorplace on [Tbl_TutorPlace].[Tutor]= [Tbl_TutorInfo].[Tutor] 
WHERE (isnull([end date]) or [end date] >=[forms]![mnu reports]![semestercut]) 
    AND [year] = [Forms]![Mnu Reports]![Year] and semester =[forms]![mnu reports]![semester]
    AND Gender = 'Male'
GROUP BY Gender