Report not counting

[pontiac]

OK, the report that I had the wizard help me with doesn't count the YES/NO (checks) that I need to add-up.. How can I count the number of check's for YES, and have it tell me the number not "YES". If "NO" put zero??

Thanks ray:

 

[Joe4]

How are you trying to count them? What is your formula?

Keep in mind that in Access, check boxes and some other "Yes/No" type fields have a value of -1 for "Yes" and 0 for "No".

 

[pontiac]

OK, New to Access. I had the wizard set-up that stuff.. How can I see the formula and sed that to you??

 

[Joe4]

Go to Design View of the Report, locate the field, look at the Properties of the field and see what the Control Source is. It should be some sort of calculation.

Is there a value being returned currently?