Solved

Count Character in multiple field

Posted on 2016-09-04
4
32 Views
Last Modified: 2016-10-08
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
Comment
Question by:plut sultra
  • 2
  • 2
4 Comments
 
LVL 19

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 250 total points (awarded by participants)
ID: 41784274
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
 
LVL 49

Assisted Solution

by:Gustav Brock
Gustav Brock earned 250 total points (awarded by participants)
ID: 41784493
As you stipulate it, it is a task for a spreadsheet.

/gustav
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 41804510
I suggest a delete.

/gustav
0
 
LVL 19
ID: 41834877
no response from poster
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question