我如何绘制几个研讨会的不同出现次数？ [英] how do I chart the number of distinct occurances of several workshops?
问题描述
我如何绘制或计算报告来计算值1到5的不同出现，比如10个研讨会。我在MS Access中有下表：
ID Workshop1 Workshop2 Workshop3 Workshop4 ....
1 ..... 3 ......... ...... 2 .................. 4 ................. 1
2 ...... 2 ................. 2 .................. 2 ... ............... 5
3 ..... 2 ................. 1 .. ................. 5 ................. 5
4 ..... 3 .................. 3 .................. 4 ........... .... 3
......等
我算了一次研讨会的出现次数：
SELECT DISTINCT people.workshop1，Count（people.workshop1）AS CountOfworkshop1 FROM人GROUP BY people.workshop1;
但我需要在MS Access的一个图表/图表中为大约10个研讨会绘制图表。
谢谢。
Hi,
How do I chart or calculate a report to count the distinct occurances of the values 1 to 5 for lets say 10 workshops. I have the following table in MS Access:
ID Workshop1 Workshop2 Workshop3 Workshop4 ....
1 ..... 3 ............... 2 ..................4 .................1
2 ......2 .................2 ..................2.................5
3..... 2 .................1 ...................5.................5
4 ..... 3..................3.................. 4 ............... 3
......etc
I counted the number of occurances for one workshop:
SELECT DISTINCT people.workshop1, Count(people.workshop1) AS CountOfworkshop1 FROM people GROUP BY people.workshop1;
But I need to chart it for about 10 workshops in the one graph/chart in MS Access.
thanks.
推荐答案
如何我可以绘制或计算一份报告，以计算值1到5的不同出现次数。我在MS Access中有下表：
ID Workshop1 Workshop2 Workshop3 Workshop4 ....
1 ..... 3 ......... ...... 2 .................. 4 ................. 1
2 ...... 2 ................. 2 .................. 2 ... ............... 5
3 ..... 2 ................. 1 .. ................. 5 ................. 5
4 ..... 3 .................. 3 .................. 4 ........... .... 3
......等
我算了一次研讨会的出现次数：
SELECT DISTINCT people.workshop1，Count（people.workshop1）AS CountOfworkshop1 FROM人GROUP BY people.workshop1;
但我需要在MS Access的一个图表/图表中为大约10个研讨会绘制图表。
谢谢。
Hi,
How do I chart or calculate a report to count the distinct occurances of the values 1 to 5 for lets say 10 workshops. I have the following table in MS Access:
ID Workshop1 Workshop2 Workshop3 Workshop4 ....
1 ..... 3 ............... 2 ..................4 .................1
2 ......2 .................2 ..................2.................5
3..... 2 .................1 ...................5.................5
4 ..... 3..................3.................. 4 ............... 3
......etc
I counted the number of occurances for one workshop:
SELECT DISTINCT people.workshop1, Count(people.workshop1) AS CountOfworkshop1 FROM people GROUP BY people.workshop1;
But I need to chart it for about 10 workshops in the one graph/chart in MS Access.
thanks.
只是一个需要澄清的问题 - 这10个研讨会是什么？表中的10个字段（或字段组）？还是10张独立的桌子？或者表中的10条记录？从显示的布局，我猜第一个选项？
Just a question for clarification - are these 10 "workshops" 10 fields (or groups of fields) in a table? Or 10 separate tables? Or 10 records in a table? From the layout shown, I''m guessing the first option?
我该怎么办？图表或计算报告以计算值1到5的不同出现，比如10个研讨会。我在MS Access中有下表：
ID Workshop1 Workshop2 Workshop3 Workshop4 ....
1 ..... 3 ......... ...... 2 .................. 4 ................. 1
2 ...... 2 ................. 2 .................. 2 ... ............... 5
3 ..... 2 ................. 1 .. ................. 5 ................. 5
4 ..... 3 .................. 3 .................. 4 ........... .... 3
......等
我算了一次研讨会的出现次数：
SELECT DISTINCT people.workshop1，Count（people.workshop1）AS CountOfworkshop1 FROM人GROUP BY people.workshop1;
但我需要在MS Access的一个图表/图表中为大约10个研讨会绘制图表。
谢谢。
Hi,
How do I chart or calculate a report to count the distinct occurances of the values 1 to 5 for lets say 10 workshops. I have the following table in MS Access:
ID Workshop1 Workshop2 Workshop3 Workshop4 ....
1 ..... 3 ............... 2 ..................4 .................1
2 ......2 .................2 ..................2.................5
3..... 2 .................1 ...................5.................5
4 ..... 3..................3.................. 4 ............... 3
......etc
I counted the number of occurances for one workshop:
SELECT DISTINCT people.workshop1, Count(people.workshop1) AS CountOfworkshop1 FROM people GROUP BY people.workshop1;
But I need to chart it for about 10 workshops in the one graph/chart in MS Access.
thanks.
不幸的是，没有简单的方法可以做到这一点。以下内容将涵盖4个研讨会领域，您需要将其调整为10个。
SELECT" 1"作为TempVal，
总和（IIf（[workshop1] = 1,1,0））AS CountWk1，
总和（IIf（[workshop2] = 1,1,0 ））作为CountWk2，
总和（IIf（[workshop3] = 1,1,0））AS CountWk3，
总和（IIf（[workshop4] = 1,1 ，0））AS CountWk4，
来自人们
UNION
SELECT" 2" AS TempVal，
总和（IIf（[workshop1] = 2,1,0））AS CountWk1，
总和（IIf（[workshop2] = 2,1,0 ））作为CountWk2，
总和（IIf（[workshop3] = 2,1,0））AS CountWk3，
总和（IIf（[workshop4] = 2,1 ，0））AS CountWk4
来自人们
UNION
SELECT" 3" AS TempVal，
总和（IIf（[workshop1] = 3,1,0））AS CountWk1，
总和（IIf（[workshop2] = 3,1,0 ））作为CountWk2，
总和（IIf（[workshop3] = 3,1,0））AS CountWk3，
总和（IIf（[workshop4] = 3,1 ，0））AS CountWk4
来自人们
UNION
SELECT" 4" AS TempVal，
总和（IIf（[workshop1] = 4,1,0））AS CountWk1，
总和（IIf（[workshop2] = 4,1,0 ））作为CountWk2，
总和（IIf（[workshop3] = 4,1,0））AS CountWk3，
总和（IIf（[workshop4] = 4,1 ，0））AS CountWk4
来自人们
UNION
SELECT" 5" AS TempVal，
总和（IIf（[workshop1] = 5,1,0））AS CountWk1，
总和（IIf（[workshop2] = 5,1,0 ））作为CountWk2，
总和（IIf（[workshop3] = 5,1,0））AS CountWk3，
总和（IIf（[workshop4] = 5,1 ，0））AS CountWk4
来自人;
Unfortunately, there is no easy way to do this. The following will cover 4 workshop fields you will need to adapt it to cover 10.
SELECT "1" As TempVal,
Sum(IIf([workshop1]=1,1,0)) AS CountWk1,
Sum(IIf([workshop2]=1,1,0)) AS CountWk2,
Sum(IIf([workshop3]=1,1,0)) AS CountWk3,
Sum(IIf([workshop4]=1,1,0)) AS CountWk4,
FROM people
UNION
SELECT "2" AS TempVal,
Sum(IIf([workshop1]=2,1,0)) AS CountWk1,
Sum(IIf([workshop2]=2,1,0)) AS CountWk2,
Sum(IIf([workshop3]=2,1,0)) AS CountWk3,
Sum(IIf([workshop4]=2,1,0)) AS CountWk4
FROM people
UNION
SELECT "3" AS TempVal,
Sum(IIf([workshop1]=3,1,0)) AS CountWk1,
Sum(IIf([workshop2]=3,1,0)) AS CountWk2,
Sum(IIf([workshop3]=3,1,0)) AS CountWk3,
Sum(IIf([workshop4]=3,1,0)) AS CountWk4
FROM people
UNION
SELECT "4" AS TempVal,
Sum(IIf([workshop1]=4,1,0)) AS CountWk1,
Sum(IIf([workshop2]=4,1,0)) AS CountWk2,
Sum(IIf([workshop3]=4,1,0)) AS CountWk3,
Sum(IIf([workshop4]=4,1,0)) AS CountWk4
FROM people
UNION
SELECT "5" AS TempVal,
Sum(IIf([workshop1]=5,1,0)) AS CountWk1,
Sum(IIf([workshop2]=5,1,0)) AS CountWk2,
Sum(IIf([workshop3]=5,1,0)) AS CountWk3,
Sum(IIf([workshop4]=5,1,0)) AS CountWk4
FROM people;
你可以查看CrossTab查询。
我自己很缺乏经验，但是我认为这值得一看。
You could look at CrossTab queries.
Very inexperienced in those myself, but this is worth a look I think.
这篇关于我如何绘制几个研讨会的不同出现次数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
