Results 1 to 7 of 7
  1. #1
    faiz786 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    3

    Student Attendance Register

    Hello



    I have two tables (microsoft access). Table A contains all personal details of all students. Table B only contains number of days a particular student has been absent.

    I want to create a report which shows % attendance for all students.

    Please note that NOT all students will be in table B as some may have full attendance.

    What is the best way to get this info?

    Thanks in advance.

  2. #2
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    In order to report the % attendance vs. absenteeism, you need to track the number of attendance opportunities - I don't see that in your two tables. Sounds like you are only storing a count? If so, I would revise that and record the dates the student was absent, then you can do a Count() to get the number of absent days.

  3. #3
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Impossible without how many days are in the school year (to date or overall)


    How are you going to get that?

  4. #4
    faiz786 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    3
    Table c will contain month and study days...

  5. #5
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    To assist further we would need the layout of ALL tables related to this process you wish to develop. Sample data would help also.

  6. #6
    faiz786 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    3
    Table A:
    Student Id (Pk)
    First name
    Last name
    Class
    Status (active or inavtive)
    Start date

    Table b
    Id (pk)
    Student id
    Absences

    Table c
    Id
    Class
    Total Study days
    Month
    Year

    I want end result from query for ALL active students to be:
    Student id
    Status (active)
    % attendance

  7. #7
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 11-21-2016, 05:02 AM
  2. Replies: 2
    Last Post: 07-21-2014, 08:47 AM
  3. Using Calender Form for Student Attendance
    By GSP101 in forum Database Design
    Replies: 6
    Last Post: 02-28-2013, 02:10 AM
  4. Append Query - Student Attendance
    By Daryl2106 in forum Access
    Replies: 5
    Last Post: 10-24-2012, 01:42 PM
  5. Replies: 5
    Last Post: 03-21-2012, 07:13 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums