Below is the SQL I am using to have my app display only the count of records that have IT in their title and have earned the IDW qualification.
strSQL = "SELECT Count(tblMember.COMPASSID) AS MemberCount " & _
"FROM tblMember " & _
"WHERE Left$(RankRate, 2 ) = 'IT' and (tblMember.PrimaryWarfareDesignator) Like 'IDW' and ((tblMember.DelStatus)=False)and((tblMember.Civilian)=False);"
Only I keep getting a syntax error on the statement.