hi guys.
i'm trying to create a access database with vba coding for a attendance notebook whereby it will do the calculations for the attendance percentage upon changes made in the field

e.g.

john mary harry tom ken
DAY1 P P P P P
DAY2 P P A A A
DAY3 A A P P P
DAY4 P P P P A
DAY5 A P P P P

percentage 60% 80% 80% 80% 60%


what i mean is, if i were to change the number of days, and change the no. of P(present) and A(absent)
the field in the percentage rows will automatically calculate the percentage of the attendance for that particular row.

is this possible? thx for ani enlightening help