Click here to Skip to main content
11,583,859 members (65,383 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#
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
Edited 27-Jan-13 2:21am
v4
Comments
CHill60 at 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
0 OriginalGriff 480
1 Sergey Alexandrovich Kryukov 285
2 virusstorm 268
3 Dave Kreskowiak 230
4 Richard Deeming 220
0 OriginalGriff 1,523
1 Sergey Alexandrovich Kryukov 995
2 Abhinav S 696
3 Dave Kreskowiak 621
4 Suvendu Shekhar Giri 568


Advertise | Privacy | Mobile
Web03 | 2.8.150603.1 | Last Updated 27 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

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