Count If

[randolphoralph]

I have uploaded the spreadsheet for review. On the Form titled "HCF Audit"

Fields
Correct TOS and Suffix Selected-contains "Yes", "No", or "N/A"
Correct POT (Place of Treatment)-contains "Yes", "No", or "N/A"
Correct DOS entered on Maintenance Screen-contains "Yes", "No", or "N/A"
Total Possible Points-Is where I need help

So for Example if the record showed the following:

Correct TOS and Suffix Selected=Yes or No
Correct POT (Place of Treatment)=Yes or No
Correct DOS entered on Maintenance Screen= Yes or No
Total Possible Points=3

Correct TOS and Suffix Selected=N/A
Correct POT (Place of Treatment)=N/A
Correct DOS entered on Maintenance Screen= N/A
Total Possible Points=0

Correct TOS and Suffix Selected=Yes or No
Correct POT (Place of Treatment)=Yes or No
Correct DOS entered on Maintenance Screen= N/A
Total Possible Points=2

ETC.......

I am looking to get the field Total Possible Points to count only the specific record not all the records. So if I were to go to the next record the Total Possible Points field would reflect 0 until information was entered on the 2nd record.

Is it possible to update the field Total Possible Points in the underlying table for each record?

 

[khawar]

Why do you want to store it in table when it can be done in the equery