• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 53
  • Last Modified:

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
0
plut sultra
Asked:
plut sultra
  • 2
  • 2
2 Solutions
 
crystal (strive4peace) - Microsoft MVP, AccessRemote 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 BrockCIOCommented:
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now