Hello,

I have a field which contains a value list of check boxes with 7 skills which a user can select. I would like to know how many times certain items were selected and by gender.

Is FMP able to perform such a summary?

Thanks in advance

DH

Edited June 24, 200718 yr by Guest

To do this, don't use a single text field to hold the data.

Instead use a relational structure. Make each item a related record. In the master record, use a portal to display the results and allow data entry.

With each item as a separate record, generating statistics is a simple matter of making a summary report.

Normalizing the value list isn't necessary to get make a sub-summary report from the values.

You'd have a Sub-Summary by whatever-the-field-is part, and another Sub-Summary by Gender part. Place whatever-the-field-is and the Gender field on their corresponding part, sort the found set by whatever-the-field-is and Gender, add a Summary Count of RecordID field to whichever parts, and view the records in Preview Mode, or print to get the values to show up.

"Normalizing the value list isn't necessary to get make a sub-summary report from the values."

It is if a count of individual items is wanted.

Oops, you're right. I must have been thinking about something else. I gotta stop eating those mushrooms...