Counting Y/N Records

[Guest]

In the survey form I'm making, I would like the total of all the records for
each question to show in the footer section. The questions are Y/N fields.

Thanks in advance, Shannon

PS, I already asked this, but can't find it. Is there a way to sort posts?

 

[fredg]

In the survey form I'm making, I would like the total of all the records for
each question to show in the footer section. The questions are Y/N fields.

Thanks in advance, Shannon

PS, I already asked this, but can't find it. Is there a way to sort posts?

In the Report Footer?
Y/N fields meaning they are Check Box fields?

Yes replies:
=ABS(Sum([CheckName]))

No replies:
=Sum([CheckName]+1)

 

[Guest]

That's exactly what I needed! Thanks!

In the survey form I'm making, I would like the total of all the records for
each question to show in the footer section. The questions are Y/N fields.

Thanks in advance, Shannon

PS, I already asked this, but can't find it. Is there a way to sort posts?

In the Report Footer?
Y/N fields meaning they are Check Box fields?

Yes replies:
=ABS(Sum([CheckName]))

No replies:
=Sum([CheckName]+1)

 

[Guest]

I was able to do that for the first nine entries. On the tenth entry, they
all displayed "err#." Do you know what to do? I have many entries.

In the survey form I'm making, I would like the total of all the records for
each question to show in the footer section. The questions are Y/N fields.

Thanks in advance, Shannon

PS, I already asked this, but can't find it. Is there a way to sort posts?

In the Report Footer?
Y/N fields meaning they are Check Box fields?

Yes replies:
=ABS(Sum([CheckName]))

No replies:
=Sum([CheckName]+1)