How to count and show percentage for "yes" or "no" records on a form?

[gina farrow]

I have a form that has yes or no answer. I need to know how to count how many yeses and how many nos on the form. and then show a precentage of how many records said yes and no.

[gina farrow]

would I have to use a query first?

[Rabbit]

These are all different fields? You would need a very long string of IIf() statements.

[gina farrow]

yes,for each column I need to count how many yeses and nos

[Rabbit]

You could do an aggregate query for each field or you could use the DCount function.