Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
SELECT enrollment.er_school_id, Sum(IIf([Year]=forms!select_dates!current_year,[enroll_data],0)) AS [Current Enrollment], Sum(IIf([Year]=forms!select_dates!proposed_year,[enroll_data],0)) AS [Proposed Enrollment], ([Proposed Enrollment]-[Current Enrollment]) AS [+/- Enrollment], schools.schoollName, schools.school_id, schools.Type FROM schools INNER JOIN enrollment ON schools.school_id = enrollment.er_school_id WHERE (((schools.open_date)<="forms]![select_dates]![current_year]") AND ((schools.close_date)>=[forms]![select_dates]![proposed_year])) GROUP BY enrollment.er_school_id, schools.schoollName, schools.school_id, schools.Type;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SSRS: Why is Visual Studio stripping these properties?||2||49|
|How to keep a record with the highest value||3||58|
|Set a variable value in SQL Procedure||3||26|
Join the community of 500,000 technology professionals and ask your questions.