If these are text fields, you can count the number of Yes answers like this
(assuming a field is named Question1):
=Sum(IIf([Question1]="yes", 1, 0))
To try to count all the yes answers across 60 fields, you would need to
create such a text box for each field, and then another text box to sum the
total, e.g.:
=[Text0] + [Text1] + [Text2] + ...
In the end, the problem is that this is completely the wrong way to design a
table in a relational database. For an explanation, see:
Don't use Yes/No fields to store preferences
at:
http://allenbrowne.com/casu-23.html
Once you understand that, if you want an example of how to design a
questionnaire database, Duane Hookom has one called At Your Survey here:
http://www.rogersaccesslibrary.com/f...-e6b9d9a3.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"JSchumacher" <(E-Mail Removed)> wrote in message
news:74C9406F-30B6-41CD-910D-(E-Mail Removed)...
> Hi.
>
> I've created a form with ~60 fields. 47 of them are combo boxes with
> 'yes',
> 'no' and 'na' options available.
>
> I'm trying to create a series of text boxes at the bottom of the form to
> show the counts of each selection (to be used later in determining a final
> score, so at the footer the user would see something like
>
> Total Questions; 74
> Total Not Applicable; 24
> Total Yes; 45
> Total No; 5
>
> I've so far tried playing around with the expression builder using the
> 'count' feature but can't quite seem to get the syntax right.
>
> Advice appreciated.
Similar Threads
