Creating Summary Report of survey

[Dave Bevis]

I am fairly new to Filemaker and need some help creating a summary report of survey responses. I need to create a report that has a count of each response submitted and what percentage of the total answers that the response represents. IN MySQL i can use a SELECT query i.e. SELECT Count(fieldname) WHERE fieldname = "value".

I need to build a report that has each of 53 fields listed with the count of each and the percentage of total for each answer for that field. i.e.

Field 1

Answer1 count %

Answer2 count %

Field 2

Answer1 count %

Answer2 count %

Etc.

I'm sure there has got to be a fairly simple way of doing this but I am not finding it. Any help you could give me will be greatly appreciated.

Thanks.

[Ender]

Welcome Dave!

I'm afraid this is not so simple with the structure you have (separate fields for each answer.) If instead the fields were line items in a related table, it would be pretty easy to summarize the way you want (with results for all questions listed on one report,) using a columnar report with sub-summary parts.

If it would work to just report on one question at a time, then see my description of a GetField() technique in this thread:

http://www.fmforums.com/threads/showflat.php?Cat=0&Board=solutions&Number=118272

If you can't change the structure, but you still need a report to show each field's counts on one report, you'll have to create an AnswerSummary table, where each record is the summary result for each answer. Then use a looping script to populate it (you can still take advantage of the GetField().)

Let us know if you have questions.