在MSaccess中如何获得输出 [英] In MSaccess how to get the output

问题描述

如下;



Sch_Date会话Fac_code课程



1/14 / 2013 1 CM AFF

1/14/2013 3 Vb AFF





但我想要输出在MSAccess数据库中







AFF（课程）

1 2 3 4

1/14/2013 CM Vb





以上输出如何在MS中编写查询访问数据库。

in MSAccess database records are as follows;

Sch_Date Session Fac_code course

1/14/2013 1 CM AFF
1/14/2013 3 Vb AFF


But i want the output in MSAccess Database



AFF(course)
1 2 3 4
1/14/2013 CM Vb


for the above output how to write query in MS Access Data Base.

推荐答案

请查看以下两个论坛和文章，

http://stackoverflow.com/questions/6571470/ms-access-2010-sql-query-help [ ^ ]

http://www.fmsinc.com/tpapers/queries/crosstab.html [ ^ ]

Please check following two forum and article,
http://stackoverflow.com/questions/6571470/ms-access-2010-sql-query-help[^]
http://www.fmsinc.com/tpapers/queries/crosstab.html[^]

这篇关于在MSaccess中如何获得输出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！