In access 2010 summary report footer I want to find out no of instances where Field-1=0 and Field-2 > 70
I tried the following expressions :
=DCount("[Field-1]","ReportName","[Field-2]=70" And "[Field-1] > 0") This is just giving total nos of records in the report , not filtered
=DCount("[Field-1]","ReportName","[Field-2]"=70 And "[Field-1]" > 0") This is giving #Type error
Pl suggest a solution