C
Celeste
I would like to sum values across multiples fields but the values in the
fields I need are letters. So, is it possible to assign a value to each
letter and then take the sum?
For example, if this was an attendance record.
Week 1 = A
Week 2 = P
Week 3 = P
Week 4 = TA
And I would want to count the number of Absences (A) for these four weeks so
I would need to assign A=1, P=0, and TA=.5 (since 2 Tardies = 1 Absence).
Can I do this? And how?
fields I need are letters. So, is it possible to assign a value to each
letter and then take the sum?
For example, if this was an attendance record.
Week 1 = A
Week 2 = P
Week 3 = P
Week 4 = TA
And I would want to count the number of Absences (A) for these four weeks so
I would need to assign A=1, P=0, and TA=.5 (since 2 Tardies = 1 Absence).
Can I do this? And how?