Thanks Ali, I just had to remove the = before the first IIf and it worked
=sum(IIf([A]=0 And [b]=0,0,IIf([A]=0 And [b]=-1,0,IIf([A]=-1 And [b]=0,0,"1"))))
Now here is another one I've been struggling with for a couple of weeks.
On another report I have a query that has records with both Check box fields and Test Fields.
I was able to get a sum of all the records in that query that had the text "GAMC" in the two fields [Pl Ri Ki] & [Pl Lt Ki] by using
=Sum(IIf([Pl Rt Ki]="GAMC",1,0))+Sum(IIf([Pl Lt Ki]="GAMC",1,0))
Now I want to know how may of that text from the two fields are on the records of two check fields.
From Column A (check box yes) and Column B (check box yes), how many times was "GAMC" in {Pl Rt Ki} & {Pl Lt Ki}
Hope that makes sense and is it doable?
I think I will also start a new thread on this one.
Thanks again,
J