Click here to Skip to main content
13,737,943 members
Rate this:
Please Sign up or sign in to vote.
See more:
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?
Posted 27-Jan-13 1:42am
Updated 27-Jan-13 2:21am
CHill60 27-Jan-13 11:21am
The problem is likely to be in the function "Conc" - what does it do?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Cookies | Terms of Service
Web04-2016 | 2.8.180920.1 | Last Updated 27 Jan 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100