Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2008
    Posts
    8

    Unanswered: Microsoft Access Query or Table ???? Please help me.

    Hello,

    I have a problem and I hope someone could help me with this.

    I have a student registration database.
    The case is that there is courses that student can register in.
    And when they register there a groups formed for the courses. So there may be 2 groups that give the same course depending on how much students register.

    The courses are divided in two levels, so there are courses that is level1, and level2.

    The level 1 courses are teached in one day. So they are one day course.
    The level 2 courses are teached in 5 days. so they are a 5 days course.

    The students can only make the exam if they attend to the courses.
    For the 1 day course they have to attend 1 time.
    For the 5 days course they have to attend at least 3 times.

    So I have made a query which I get the list of the students that can make the exams. That was easy.

    But now I have to add a mark field for only the students that was allowed to attend to make the exams.

    My problem is now that I don't know how to incorporate this table. So I can register the marks for the students that only was allowed to take the exams.
    The exams are a one time exam, so that determine if you pass the course.

    Please help me.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Well, that would depend on your current data model.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Sep 2008
    Posts
    8
    This is my data model.
    Attached Files Attached Files

  4. #4
    Join Date
    Sep 2008
    Posts
    8
    Quote Originally Posted by Teddy
    Well, that would depend on your current data model.

    Here is my data model
    Doc1.doc

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You don't have anything tracking an instance of a given class. See if you can solve that first, it will make your life easier.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  6. #6
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Good call Teddy! I knew there was something about it and then read your post.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •