Total's on A Report

[Amanda Laughlin]

Good Morning,

I am adding total's to a report that I am working on. And
one of my control's is a yes/no field. Does anyone know
how to calculate the total for only the yes's?

Any suggestions welcome, thanks in advance.

Amanda

 

[Duane Hookom]

Try:
=Abs( Sum([YesNoFld]) )

 

[Marshall Barton]

I am adding total's to a report that I am working on. And
one of my control's is a yes/no field. Does anyone know
how to calculate the total for only the yes's?

Use any of the following expressions in the report footer's
text box:

=Count(IIf(yesnofield, 1, Null)

=Sum(IIf(yesnofield, 1, 0)

=Abs(Sum(yesnofield))

the above are in descending order of clarity and ascending
order of speed.