Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: C#
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 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 can i do.
Posted 26-Jan-13 9:03am
Edited 27-Jan-13 1:09am
Mike Meinz at 26-Jan-13 17:53pm
There's no Where clause.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

i think your missing the where clause

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

  Print Answers RSS
0 OriginalGriff 587
1 Sergey Alexandrovich Kryukov 479
2 Maciej Los 305
3 Mathew Soji 195
4 Afzaal Ahmad Zeeshan 170
0 OriginalGriff 7,356
1 Sergey Alexandrovich Kryukov 6,777
2 DamithSL 5,461
3 Manas Bhardwaj 4,916
4 Maciej Los 4,475

Advertise | Privacy | Mobile
Web02 | 2.8.1411023.1 | Last Updated 27 Jan 2013
Copyright © CodeProject, 1999-2014
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