Count Character in multiple field

I make form  like this  :
                         
ID        Name Student     date1         date2          date3         date4           date5    .......  date31         sum of Present(P)     Sum of Absent(A)    
1         Robert                       P                A                  P                 P                   A                                                   3                                   2
2         Oliver                        A                P                  P                  P                   P                                                   4                                   1
3         Jacky                          P                P                   P                 P                  P                                                    5                                   0

I want when date6 for Robert Student I type  "A"  so the result in sum of Present(P) is = 3 and sum of Absent(A) is 3
plut sultraAsked:
Who is Participating?
 
crystal (strive4peace) - Microsoft MVP, AccessConnect With a Mentor Remote Training and ProgrammingCommented:
This is poor data structure.  Better would be to have a table for Attendance like this:

Attendance:
AttendanceID, AutoNumber
StudentID, Long Integer -- foreign key to Students (table with Student information)
ClassDate, date/time
AttStatus, text -- Attendance Status (A=Absent, P=Present)
0
 
Gustav BrockConnect With a Mentor CIOCommented:
As you stipulate it, it is a task for a spreadsheet.

/gustav
0
 
Gustav BrockCIOCommented:
I suggest a delete.

/gustav
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
no response from poster
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.