Total's on A Report

  • Thread starter Thread starter Amanda Laughlin
  • Start date Start date
A

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
 
Amanda said:
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?
Click to expand...

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.
 
Back
Top