Hi guys
Is it possible to have specific values and values from a select query in IN*Operator. I mean something like this
SELECT tblStudents.*, Grade
FROM tblStudents
WHERE Grade In ("A","A-","B+","B","B-","C+","C","C-","D+","D","F",
SELECT DISTINCT tblStudents AS Grade
FROM tblStudents
WHERE Grade In ("DIS","E", "W") AND Subject Like "ehs*")
)
I want to generate a crosstab query to have fixed column heading (grades A to F) but dynamic for (DIS, W, E, etc).
Your help is greatly appreciated..
Thanks
Sent from my ANE-LX1 using Tapatalk
Is it possible to have specific values and values from a select query in IN*Operator. I mean something like this
SELECT tblStudents.*, Grade
FROM tblStudents
WHERE Grade In ("A","A-","B+","B","B-","C+","C","C-","D+","D","F",
SELECT DISTINCT tblStudents AS Grade
FROM tblStudents
WHERE Grade In ("DIS","E", "W") AND Subject Like "ehs*")
)
I want to generate a crosstab query to have fixed column heading (grades A to F) but dynamic for (DIS, W, E, etc).
Your help is greatly appreciated..
Thanks
Sent from my ANE-LX1 using Tapatalk