?
Solved

Count Character in multiple field

Posted on 2016-09-04
4
Medium Priority
?
47 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 22

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 1000 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 51

Assisted Solution

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

/gustav
0
 
LVL 51

Expert Comment

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

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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

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…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

770 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