counting yes/no results

[JimmyG]

I have a form to note how new customers hear about the company I work for, the form is just a list of options with yes/no checkboxes. I want to create a query to count the number of each option to be able to then create a graph from the totals

I have tried to use the count option but this doesn't seem to work

Does anyone know how I can solve this or another method of producing the graph I need.

Thanks

 

[namliam]

A checkbox is basicaly a True/False thing.

True is equal to -1
False is equal to 0

So if you simply sum(abs([YourCheckboxField]))
and repeat that for every field you will be much closer to getting what you want....

Q: Can users click more than 1 box?

Greetz

 

[Mile-O]

Sounds like you may need to normalise your tables.

 

[JimmyG]

Cheers Namliam, thats done the trick!