结果摘要 [英] Summary of Results

问题描述

我设计了一个数据库来保存对调查的回复。我想要的是允许用户以非图形方式查看结果，因此15％表示是75％表示不，等等。我知道我可以创建计数和分组的查询，因此这些数据是可能的，但是这意味着我必须为每个问题创建一个单独的查询，并且有100多个问题，这有点荒谬。其次，我希望扩展数据库以包含为使它们易于访问而进行的所有调查，因此您可以看到为什么这会令人讨厌！我唯一的其他选项是链接到已经处理过这些信息的PDF吗？


谢谢！

I''ve designed a database to hold responses to Surveys. What I want is to allow users to look at the results in a non graphical way, so 15% said Yes 75% said no, etc. I know that I can create queries that count and group by, so those figures are possible, but this means that I have to create a seperate query for each question, and with over 100 questions this gets slightly ridiculous. Secondly, I''m going to hopefully extend the database to encompass all the surveys that have been undertaken to make them easily accessible, so you can see why this would be annoying! Is my only other option to link to a PDF with this information already processed?

Thanks!

推荐答案

取决于在数据结构中，您不必为每个问题创建单独的查询。您有哪些表格？

Depending on the structure of the data, you should not have to create a seperate query for each question. What tables do you have?

您应该能够根据调查中的每个问题进行分组，这样您的查询就会在一个查询中提出所有问题以及所有答案。


ie。

you should be able to group by each question on the survey, that way your query will have all questions asked, and all responses as well all in one query.

i.e..

展开 | 选择 | Wrap | 行号

这是一个名为问题的表格;其中包含已预先定义的答案的问题。每个字段都是一个单独的问题。我对你的回答ajalwaysus感到有些困惑，因为当你在一个查询中输入你的回答时，它会询问我所指的是哪个问题（即参数值）。我只是愚蠢吗？

It''s a table called "Questions" which contains alll the questions with their answers already predefined. Each field is a seperate question. I''m a little perplexed by your answer ajalwaysus, as when you enter your response into a query it then asks to which QUESTION am I referring (i.e. Parameter Value). Am I just being idiotic?

这篇关于结果摘要的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！