我尝试了十几次，但没有得到我所需的输出我不知道请回复 [英] I tried dozen of times but not getting my required output i dont know please reply

问题描述

我尝试了十几次但没有得到我所需的输出我不知道请回复



MS Access中的表结构

Sno Auto号码

Sch_Date日期/时间

会话编号

课程文字

Faculty_Code文件





从MS Access中的Table_Name中选择*;

Sno Sch_Date会话课程Faculty_Code

1 11/01 / 2013 1 REO GS

2 11/01/2013 1 REO VB

3 12/01/2013 1 REO NR





来自上述输出的11/01/2013（sch_date），1stsession和课程的教师代码是GS，VB（faculty_Code）仅

for 12 / 01/2013（sch_date），1stsession和课程教员代码仅限NR（faculty_Code）。



当我尝试以下查询时它与select * from不匹配Table_Name查询。



但是当我在11/01/2013（sch_Date）尝试以下查询时，第1次会话d当然所有的教师代码都来到我的下面输出why.please纠正我的下面

查询是什么错误我怎么办？

I tried dozen of times but not getting my required output i dont know please reply

Table Structure in MS Access
Sno Auto Number
Sch_Date Date/Time
Session Number
Course Text
Faculty_Code Text


Select * from Table_Name in MS Access ;
Sno Sch_Date Session Course Faculty_Code
1 11/01/2013 1 REO GS
2 11/01/2013 1 REO VB
3 12/01/2013 1 REO NR


from the above output for 11/01/2013 (sch_date),1stsession and course faculty code is GS,VB (faculty_Code) only
for 12/01/2013 (sch_date),1stsession and course faculty code is NR (faculty_Code) only.

when i try this below query it is not matching with select * from Table_Name query.

But when i try the below query for 11/01/2013 (sch_Date),1st session and course all the faculty code are coming to my below output why.please correct my below
query what is the mistake.how can i do?

SELECT Tb_Sch_TIme_Table.Sch_Date, Tb_Sch_TIme_Table.Session, Tb_Sch_TIme_Table.Course, 
Conc("Faculty_Code","Session",[Session],"Tb_Sch_TIme_Table") AS Faculty_Code
FROM Tb_Sch_TIme_Table
GROUP BY Tb_Sch_TIme_Table.Course, [Sch_Date], [Session];

< br $> b $ b



以上查询的输出如下MS Access;





Sch_Date会话课程Faculty_Code
11/01/2013 1 REO GS，NR，VB

12/01/2013 1 REO GS，NR，VB



请更正我的上述查询。我可以这样做。

Output for above query as follows MS Access;


Sch_Date Session Course Faculty_Code
11/01/2013 1 REO GS, NR, VB
12/01/2013 1 REO GS, NR, VB

Kindly please correct my above query.how can i do.

推荐答案

我认为你错过了where子句

i think your missing the where clause

这篇关于我尝试了十几次，但没有得到我所需的输出我不知道请回复的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！