I have a module .. that counts the first two letters in my field "INSP"
Function funCount1(prmSearchString As String) As String
funCount1 = DCount("[INSP]", "[qryQualityStatus]", "left([INSP],2) = '" & prmSearchString & "'")
I insert this code in my report as follows..
in a txt box ... this would count all "DR" in my "INSP" field and display the number..
Now I need the count of all data with "DR" (or the first two letters in my INSP field) AND a COUNT REJ of "Y"
REJ would be another field in my table. Both have to be met and a count of that set of records..