Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
SELECT gradelevels.Budget_code, Sum(IIf([trYear]=forms!select_dates!current_year,[TeacherFTE],0)) AS [Current Teachers], Sum(IIf([trYear]=forms!select_dates!proposed_year,[TeacherFTE],0)) AS [Proposed Teachers], ([Proposed Teachers]-[Current Teachers]) AS [+/- Teachers], Teacherresources.trschool_id, schools.schoollName, schools.Type FROM schools INNER JOIN (gradelevels RIGHT JOIN Teacherresources ON gradelevels.grade_subjectID = Teacherresources.grade_subjectid) ON schools.school_id = Teacherresources.trschool_id WHERE (((schools.open_date)<="forms]![select_dates]![current_year]") AND ((schools.close_date)>=[forms]![select_dates]![proposed_year])) GROUP BY gradelevels.Budget_code, Teacherresources.trschool_id, schools.schoollName, schools.Type ORDER BY schools.schoollName;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Update the value of table B with value of table A tables inner join||6||101|
|T-SQL Query - Group By Year||3||55|
|TSQL: return only records which have only one type of value.||1||42|
|Please explain the difference between EXCLUDE, INTERSECT and JOIN||7||52|
Join the community of 500,000 technology professionals and ask your questions.