Results 1 to 5 of 5
  1. #1
    sphirst is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2018
    Posts
    2

    Question Team Points System for Students

    Hi,



    I'm trying to create a house team points system for the students in my class.

    They are separated in to four different teams; blue, yellow, green, and red.

    Simply, it's rather easy to tally the points up for all the students and their associated teams.

    However, there are also team challenges that need to be accounted for.

    At the moment, I have a students table with all the student info. I have a house team table and a junction table that matches both of these and also has points on it.

    e.g.
    Student 1 Team 1 4points
    Student 2 Team 1 6points
    Student 3 Team 2 2 points

    I can't for the life of me think of a good way to integrate the following;
    Challenge 1 Team 1 6points
    Challenge 1 Team 2 3points

    So that somewhere in my database I have a formula that counts and displays

    Team 1 total points
    Team 2 total points
    Team 3 total points

    I feel like I'm approaching this from one certain angle and would really appreciate a different set of eyes on this and any suggestions for the best way to implement this.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    try:

    tChallenge table
    ------------
    EventID (auto)
    EventName
    date

    tTeamups table
    --------------
    TeamupID (auto)
    EventID (long)
    HomeTeam#
    VisitTeam#
    HomeTeamPts
    VisitTeamPts

  3. #3
    sphirst is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2018
    Posts
    2
    Hi ranman. I appreciate your feedback, the challenges are multi-team.

    I will elaborate further to illustrate what I mean.

    Challenge 1 = Football Tournament

    Football Tournament | Team 1 | 5 points
    Football Tournament | Team 2 | 2 points
    Football Tournament | Team 3 | 7 points
    Football Tournament | Team 4 | 3 points

    Challenge 2 = Team Quiz

    Team Quiz | Team 1 | 2 points
    Team Quiz | Team 2 | 3 points
    Team Quiz | Team 3 | 4 points
    Team Quiz | Team 4 | 6 points

    Then, my final form will have;

    Team 1
    ---------
    Student 1 | 3 points
    Student 2 | 7 points
    Student 3 | 9 points
    Team Quiz | 2 points
    Football Tournament | 5 points

    Total points = 26 points

  4. #4
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Could you not simply add a "Team Student" for each team?
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  5. #5
    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. Team Rosters
    By TAD in forum Reports
    Replies: 1
    Last Post: 05-11-2013, 11:43 PM
  2. team building database
    By ldypurple in forum Access
    Replies: 6
    Last Post: 03-06-2013, 04:34 PM
  3. Help with hockey team history database
    By Hockeyguy1924 in forum Database Design
    Replies: 20
    Last Post: 06-15-2012, 03:05 PM
  4. Sports Team database
    By Patriot7470 in forum Database Design
    Replies: 2
    Last Post: 03-17-2012, 01:50 PM
  5. A team competition report
    By JOSE LUIS in forum Reports
    Replies: 0
    Last Post: 02-04-2010, 05:14 PM

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