如何使用ms访问数据库获得以下输出。 [英] how can i get the below output using ms access database.

问题描述

查询如下;

Query as follows;

select Sch_Date,session,Faculty_Code from Tb_SCh_TIme_Table where course =  'cl2';

当我执行上述查询时，在Ms访问数据库中输出如下

< br $> b $ b

when i execute the above query,output as follows in Ms access database

Sch_Date	session	Faculty_Code
4/15/2013	1	DM
4/15/2013	2	VRV
4/16/2013	1	VRV
4/16/2013	2	AKR
4/17/2013	1	GS

从上面的输出
我想在Ms访问数据库中输出如下

from the above output i want the output as follows in Ms access database

Sch_Date	session	Faculty_Code    Comments
4/15/2013	1	DM
4/15/2013	2	VRV
4/16/2013	1	VRV
4/16/2013	2	AKR
4/17/2013	1	GS

我在上面的查询中获得以上输出如何添加评论栏。



我该怎么办？请帮帮我。



问候，

Narasiman P

for getting a above output in my above query how to add the Comments Column.

how can i do? please help me.

Regards,
Narasiman P

推荐答案

Just更改您的SQL语句



从Tb_SCh_TIme_Table中选择Sch_Date，session，Faculty_Code，其中course =''cl2'';

Just change your SQL statement from

select Sch_Date,session,Faculty_Code from Tb_SCh_TIme_Table where course = ''cl2''; to

select Sch_Date,session,Faculty_Code, Comments from Tb_SCh_TIme_Table where course = 'cl2';

您只需要添加评论字段。

You just need to add the comments field.

这篇关于如何使用ms访问数据库获得以下输出。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！