A
Aria
I'm working on my first db and have moved on to creating reports. I have a
table for Subjects with a field for priority. This table is in regards to
substitute teachers and their preferred subjects. I would like the report to
list the subjects with the sub teachers name who has priotized that subject
as one of their most preferred. A sub can be listed multiple times on the
report for each subject they prefer. The query is returning the values in the
order I would like but I also wanted the teachers listed in alphabetical
order which is the problem I am currently experiencing. I have tried sort
ascending for the last name then first name but then the subjects are not in
order. I'm new to sub reports and was wondering if that is what I need in
order to get this as needed. Can someone help me?
Here is the SQL:
SELECT tblEmployees.LastName, tblEmployees.FirstName,
tblEmployees.HomePhone, tblSubjects.SubjectName, tblSubjectsEmps.Priority
FROM tblSubjects INNER JOIN ((tblClassifications INNER JOIN tblEmployees ON
tblClassifications.ClassID = tblEmployees.ClassID) INNER JOIN tblSubjectsEmps
ON tblEmployees.EmpID = tblSubjectsEmps.EmpID) ON tblSubjects.SubjectsID =
tblSubjectsEmps.SubjectID
WHERE (((tblSubjectsEmps.Priority)<20) AND
((tblClassifications.ClassDescription)="Substitute"))
ORDER BY tblSubjects.SubjectName, tblSubjectsEmps.Priority;
table for Subjects with a field for priority. This table is in regards to
substitute teachers and their preferred subjects. I would like the report to
list the subjects with the sub teachers name who has priotized that subject
as one of their most preferred. A sub can be listed multiple times on the
report for each subject they prefer. The query is returning the values in the
order I would like but I also wanted the teachers listed in alphabetical
order which is the problem I am currently experiencing. I have tried sort
ascending for the last name then first name but then the subjects are not in
order. I'm new to sub reports and was wondering if that is what I need in
order to get this as needed. Can someone help me?
Here is the SQL:
SELECT tblEmployees.LastName, tblEmployees.FirstName,
tblEmployees.HomePhone, tblSubjects.SubjectName, tblSubjectsEmps.Priority
FROM tblSubjects INNER JOIN ((tblClassifications INNER JOIN tblEmployees ON
tblClassifications.ClassID = tblEmployees.ClassID) INNER JOIN tblSubjectsEmps
ON tblEmployees.EmpID = tblSubjectsEmps.EmpID) ON tblSubjects.SubjectsID =
tblSubjectsEmps.SubjectID
WHERE (((tblSubjectsEmps.Priority)<20) AND
((tblClassifications.ClassDescription)="Substitute"))
ORDER BY tblSubjects.SubjectName, tblSubjectsEmps.Priority;