Counting Y/N Records

S

Shannon

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?
 
F

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?
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)
 
S

Shannon

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...
 
S

Shannon

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