Yes/No Data Type porblems

[Guest]

I'm trying to create a form that will basically have a list of fields which I
was hoping to use 'Option Buttons' for. Then I was going to create a query
to count how many times each field had been selected.

Whats the best way to go about this? I usally just create my own Yes/No
field because I seem to have trouble calculating with the actual Yes No data
type.

Please help Ian

Not even sure if I've placed this question under the right heading.

 

[John Vinson]

I'm trying to create a form that will basically have a list of fields which I
was hoping to use 'Option Buttons' for. Then I was going to create a query
to count how many times each field had been selected.

Whats the best way to go about this? I usally just create my own Yes/No
field because I seem to have trouble calculating with the actual Yes No data
type.

Please help Ian

Not even sure if I've placed this question under the right heading.

Ummm... what problems?

Yes is stored as -1. No is stored as 0.

If you want to count the number of records with Yes answers, use a
Totals query and calculate the Sum of Abs([yesnofield]). To count the
No answers, calculate the Sum of [yesnofield] + 1.

John W. Vinson[MVP]