Survey Results

[fischman]

I've created a database to survey training needs. I know about the limitations of radio boxes and check boxes, but I had to use them to facilitate record entry for teachers. Is there still some way to summarize survey results with these types of fields? I can email database.

[Chuck]

Sure, you just need to do a little extra work.

Let's say that a particular radio button can have three choices: Red, Green, and Blue. You want to know what percentage of the choises are of each color.

Create three fields: Is_Red, Is_Green and Is_Blue and make them number calculation fields. The calc for Is_Red would be

Color = "Red"

Where Color is the field where the choice is made. The calculation returns a 1 if the Red is checked and 0 if Red is not checked.

Then you can create summary fields that total these "bucket" fields to get the number for each color and the total for the found set.

Chuck