Skip to main content
Question

Counting record based on a criteria

  • May 15, 2019
  • 0 replies
  • 40 views
Hello! I have two tables: Classes and Students.

Classes fields: Class Name, Teacher, and Start Date
Students fields: Name, Class Name, and Start Date

Someone will enter records in the Classes table. Records of able are being populated from other apps. I want to count the number of students with the same class and start date in the Students table and put it in the Classes table. I tried summary fields in the relationship section but it doesn't seem to work.
    This topic has been closed for replies.

    My suggestion is to change the structure of your app.

    It should be set up like

    One Course Master has Many Scheduled Courses. 

    The Course Master is like the catalogue of the course content.

    The Scheduled Course is saying that say Economics 101 will be run  in the Fall 2018 semester. 

    Then One Scheduled Class will have many Student Class Registrations.

    One Student will have Many Student Class Registrations.
    Terms & ConditionsAccessibility statement