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];
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.