Creating a Tabular Summary

[rmalott]

My apologies in advance if this has been asked before but I've been searching and haven't found a very good solution.

I'd like to summarize some survey responses, e.g. for a particular question, 5 answered 'always', 2 answered 'never', etc.

I have the data right now with each question as a field and the text response, e.g. 'Always' for each respondent.

But, I would like to display a tabular summary report, for example each response being a field, and the field value being the total count of that response (each record would be the question). I hope that explanation makes sense, it's easier to picture in excel, which might be the better location for it, except to add to it, I'd like to have querying capabilities, like I want to see the count of responses for a certain size of institutions, or a certain collection type, etc. I was thinking of making calculated fields for each one separately, except that my number of fields would go up exponentially! If anyone has any ideas, I'd appreciate it. I'm trying to avoid using scripts (mainly since I haven't figured out how to use them yet) but I would be open to it if that will help me avoid making a gazillion fields.

Thanks!

[Ender]

See if this helps:

 

http://www.fmforums.com/forum/showtopic.php?tid/173576/

[rmalott]

Thanks for your quick response. I have FMP 9 and tried opening the survey DB but when I click on report it says 'Question_response' could not be opened (and if I go back to select the survey db again it goes into an endless loop )

But, I also like your second suggestion and will attempt that.

Thanks!

[Ender]

You need to convert both files to .fp7. Try dragging them both together onto the FileMaker Pro icon (or however you open multiple files in Windows).