AnsweredAssumed Answered

How to create a calculation that counts records by variables; IDStudent, code and date

Question asked by tzaluski on Jan 26, 2010
Latest reply on Jan 27, 2010 by philmodjunk

Title

How to create a calculation that counts records by variables; IDStudent, code and date

Post

Problem:

I need to create a field that will count the number of each attendance code in one day for one student,

then calculate if it is a Day_Late or Day_Early and have it included in the SumCode field for that

code. 

Everything works fine now, however we are replacing Day Early and Day Late with SignIn And SignOut.

Then using the same Attendance report which is a subsummary on IDStudent 

 

Attendance codes:

Day_Absent

(Day_Late)

(Day_Early) 

Sign_In

Sign_Out 

 

How many SignIn and Signout codes on each day for one student within the found set.

Then calculate whether the formula would result in a Day_Late, Day_Early or nothing.

 

Example:

1/1/2009  ID1500   signin          

1/1/2009  ID1500   signout

1/1/2009  ID1500   signin

 

1/2/2009  ID1500   signout

 

1/15/2009 ID1500  signin

 

1/22/2009 ID1500  signout 

1/22/2009 ID1500  signin 

 

the result for the found set:

1/1/2009  ID1500 DayLate    (Signed in Late, Signed out for appointment (DayEarly), signed back in again from appointment)   

1/2/2009  ID1500 DayEarly

1/15/2009 ID1500 DayLate

1/22/2009 ID1500 nothing 

 

Attendance sheet would show (sumsummary report on IDSTUDENT)

Day Late      2

Day Early    1 

Day Absent   0 (this works fine) 

Outcomes