I'm such a newbie, I don't even know if I'm posting this question in the right forum. I scoured the documentation and the web for a solution, and have dissected every file I could get my hands, but to no avail.
I conducted a survey (in meatspace, on paper) and have made a Filemaker file with a record for each respondent. I need to summarize responses to multiple-choice questions, e.g. the number of respondents who chose "B" in a given question, and what percentage of all the responses that represents. This is easy to do if you want to get an average for a numerical value, but how do I do this with non-numerical values?
Here's a real specific example. This was a survey of about 750 Japanese high school students about their comic-book reading practices. One question is "How often do you read comics?" In my Filemaker file, I created a a text field that is a pop-up field with 6 values: "Almost everday," "Several times a week," "Once a week," "Once a month," "Rarely," and "No response." I'd like to create a layout that summarizes the data in all the records. It would be even better if I could create separate summaries by sex, age, et cetera.
Do I do this with a calculation? With a script? Any help would be enormously appreciated. Thanks in advance!
[ September 07, 2001: Message edited by: Matt Thorn ]