Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Creating a Tabular Summary


Recommended Posts

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.


Link to comment
Share on other sites

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.


Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use