Access 2010 Transpose需要帮助 [英] Access 2010 Transpose Help Needed
问题描述
我已经全神贯过地回答了我所说的思想。这是一个简单的问题。运行Access 2010.
表格的设置如下:
ID |日期| DayofWeek | Class1 | Class2 | Class3
1 | 2016年8月1日|星期一| X | NULL | NULL
2 | 2016年8月2日|星期二| NULL | X | NULL
3 | 2016年8月3日|星期三| X | X | X
等....
我要做的就是为某个月制作一份报告来转换数据,使其看起来像:
班级| 8/1/2016 | 8/2/2016 | 2016年8月3日....
DayofWeek |星期一|星期二|星期三....
Class1 | X | NULL | NULL ....
Class2 | NULL | X | NULL ....
Class3 | X | X | X ....
我已经尝试过各种各样的方式,但我想这并不像我想象的那么简单!为了增加乐趣,每个月的课程数量都会发生变化。帮助!
非常感谢任何帮助。
谢谢。
I''ve looked all over for an answer to what I "thought" was a simple issue. Running Access 2010.
Table is a schedule set up as follows:
ID | Date | DayofWeek | Class1 | Class2 | Class3
1 | 8/1/2016| Monday | X | NULL | NULL
2 | 8/2/2016| Tuesday | NULL | X | NULL
3 | 8/3/2016| Wednesday | X | X | X
etc....
What I''m trying to do is make a report for a given month which transposes the data so it looks like:
Class | 8/1/2016 | 8/2/2016 | 8/3/2016 ....
DayofWeek| Monday | Tuesday | Wednesday ....
Class1 | X | NULL |NULL ....
Class2 |NULL | X | NULL ....
Class3 | X | X | X ....
I''ve tried every way I can think, but I guess it''s not as simple as I assumed! To add even more fun, the number of Classes can change each month. HELP!
Any help is greatly appreciated.
Thanks.
推荐答案
你有没有尝试过交叉表查询?
Have you tried a crosstab query?
我已经看过了,但我承认失败了。我似乎无法弄明白。我看了一些例子,但是我不太了解它们能够分辨它们如何工作以适用于我正在尝试做的事情。
I''ve looked at it, but I''ve admitted defeat on it. I can''t seem to figure it out. I''ve looked at examples, but I don''t understand them enough to be able to disect how they work to be able to apply to what I''m trying to do.
- 这不是那么容易,但可以做到。首先,我有一个简单的问题。不应该转置数据(禁止日期格式):
- This won''t be that easy, but it can be done. First, I have a simple question. Shouldn''t the Transposed Data look like (barring Date Formatting):
这篇关于Access 2010 Transpose需要帮助的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!