I created a form that looks something like this:

***DETAIL***

N/A 1.Question?
Compliant 2.Question?
Not Compliant 3.Question?
Compliant 4.Question?
Not Compliant 5.Question?

and so on.....
************

***FOOTER****
Total N/A: _______
Total Complaint: _________
Total Not Compliant: _________
*************

NOTE: N/A, Compliant and Not Compliant are in a drop down menu or combo box.

My question is, how can I have it calculate the total number of N/A's, Compliant's and Not Compliant's in the footer from the detail section?

If possible, please provide the the whole expression.

Thanks is advance.

Sum(Iif([MyField]="N/A",1,0))