My below typed in the MS Access database
Select * from Tb_Sch_TIme_Table;
Sno Sch_Date Session Course Faculty_Code
1 12/01/2013 1 AFF GS
2 12/01/2013 1 AFF NR
3 13/01/2013 1 TFC VB
I tried the below query several times, but I am not getting the correct output.
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 as follows using the above query;
Sch_Date Session Course Faculty_Code
12/01/2013 1 AFF GS, NR, VB
13/01/2013 1 TFC GS, NR, VB
The above output is not correct.
I need the output as follows (compare with
Select * from Tb_Sch_TIme_Table
)
Sch_Date Session Course Faculty_Code
12/01/2013 1 AFF GS, NR
13/01/2013 1 TFC VB
How can I achieve this?
I tried several times, but my output is not matching with
select * from Tb_Sch_TIme_Table
.
From my above query what is the mistake?
Where in the table can I set primary key for column?
Suppose I would like to set primary key in which field I want to set?
Help me?