在Ms access数据库中，我需要上面的输出 [英] In Ms access database i required the above output

问题描述

Tb_Sch_Time_Table在MS访问数据库中记录如下。





Faculty_Code Sch_Date Session





CAN 4/15/2013 3

VB 4/15/2013 4

AKR 4/16/2013 3

CAN 4/16/2013 4

VB 4/17/2013 3

UNNI 4/17/2013 4

CAN 4/18/2013 3

UNNI 4/18/2013 4

VRV 4/19/2013 3

SAN 4 / 19/2013 4





使用上面的表格记录我想在ms访问数据库中输出如下





Sch_Date session3 Session4



4/15/2013 CAN VB

4/16/2013 AKR CAN

4/17/2013 VB UNNI

4/18/2013 CAN UNNI

4 / 19/2013 VRV SAN



获得高于输出我该怎么办？在MS Access数据库中。



问候，

Narasiman P.

Tb_Sch_Time_Table records as follows in MS access database.


Faculty_Code Sch_Date Session


CAN 4/15/2013 3
VB 4/15/2013 4
AKR 4/16/2013 3
CAN 4/16/2013 4
VB 4/17/2013 3
UNNI 4/17/2013 4
CAN 4/18/2013 3
UNNI 4/18/2013 4
VRV 4/19/2013 3
SAN 4/19/2013 4


from using the above table records i want the output as follows in ms access database


Sch_Date session3 Session4

4/15/2013 CAN VB
4/16/2013 AKR CAN
4/17/2013 VB UNNI
4/18/2013 CAN UNNI
4/19/2013 VRV SAN

for getting above output how can i do in MS Access Database.

Regards,
Narasiman P.

推荐答案

使用交叉表查询向导在表上创建交叉表查询。将日期作为行标题，将会话作为列标题。

Create a crosstab query on the table, using the Crosstab Query Wizard. Put the date as the row heading and Session as Column heading.

这篇关于在Ms access数据库中，我需要上面的输出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！