Counting Y/N Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

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

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

No replies:
=Sum([CheckName]+1)
 
That's exactly what I needed! Thanks!

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

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

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

No replies:
=Sum([CheckName]+1)
Click to expand...
 
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.

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

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

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

No replies:
=Sum([CheckName]+1)
Click to expand...
 
Back
Top