Click here to Skip to main content
13,410,621 members (34,385 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
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.
Posted 26-Jan-13 9:03am
Updated 27-Jan-13 1:09am
v2
Comments
Mike Meinz 26-Jan-13 17:53pm
   
There's no Where clause.

1 solution

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

Solution 1

i think your missing the where clause
  Permalink  

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 |
Web01 | 2.8.180221.1 | Last Updated 27 Jan 2013
Copyright © CodeProject, 1999-2018
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