Totaling Yes's

[belczyk]

I need to do a total of the completed (yes or no) for each section.

Example

Yes No
Personnel Readiness Complete Filing X
Personnel Readiness Complete Filing 1
X



Complete Not Complete

Personnel Readiness
1 1

 

[Dhonan]

I am not sure if this is for a form or a report or what. But you might want
to consider using the Dcount function.

 

[John W. Vinson]

I need to do a total of the completed (yes or no) for each section.

A Yes/No field is stored internally as a number: -1 for Yes, 0 for No. So you
can simply take the negative of the sum of a yes/no field to count Yes values,
or

Sum(1+[yesnofield])

for Nos.

John W. Vinson [MVP]

 

[Ken Sheridan]

If you prefer to avoid what the head of one software company of my
acquaintance once called "being unduly chummy with the implementation" you
can sum the results of an expression which returns 0 or 1.

To sum the yesses:

Sum(IIF([YesNoField],1,0))

To sum the nos:

Sum(IIF([YesNoField],0,1))

Ken Sheridan
Stafford, England

 

[belczyk]

If you prefer to avoid what the head of one software company of my
acquaintance once called "being unduly chummy with the implementation" you
can sum the results of an expression which returns 0 or 1.

To sum the yesses:

Sum(IIF([YesNoField],1,0))

To sum the nos:

Sum(IIF([YesNoField],0,1))

Ken Sheridan
Stafford, England

I need to do a total of the completed (yes or no) for each section.

Yes No
Personnel Readiness Complete Filing X
Personnel Readiness Complete Filing 1
X

Complete Not Complete

Personnel Readiness
1 1- Hide quoted text -

- Show quoted text -

Thank you everyone for all the help.