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.

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.