RexHelios (4/2/2013)
Seems quite interesting. Could you provide the following additional info?What is the from date for a term?
Not sure what you are asking here. You get the EndDate (Date datatype) from the Terms table based on the SchoolYR, LocID, Term from the TestScores.
How do you account for fractions? In other words, if a student missed a total 15 periods in a term, how many days would be calculated as?
- Rex
Fractions are dropped off, you must have 8 periods for it to be a day missed. A toal of 15 periods in a term would = 1 day (COUNT(DateABS)/8) would give you 1.