Cleaning up Queries

[shifty]

So I just made this and was thinking it is kind of rough. What steps do you guys go about to make a cleaner query? I got lucky because there is only 1 class of IS358.01 but I am trying to get a foundation on what to look at in the future.



SELECT COUNT(Student.[Student Name]) AS [Number of Students in IS353 And IS358]



FROM Student



WHERE (Class1 ) IN ("IS353.01","IS353.02") AND ((Class2 ) IN ("IS358.01") OR (Class3 ) IN ("IS358.01") OR (Class4 ) IN ("IS358.01") OR (Class5 ) IN ("IS358.01") OR (Class6 ) IN ("IS358.01"));

[ItsMe]

This is where Object Oriented Programming becomes very helpful. Rather than using "Magic Strings", where the value is hardcoded, use variables.