Results 1 to 4 of 4
  1. #1
    ScottJ is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2020
    Posts
    2

    report fields to show only the latest results

    Hi,

    I have a database of test results and the pass mark in 75%

    If a student takes more that 1 attempt how can I only show only the latest score?

    I have fields like:
    Excel test date


    Excel score
    Excel test date 2
    Excel score 2

    There are 7 tests each with a diagnostic and certification so there are already many fields on the report.

    thanks

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Your structure is all wrong. What if they have 3 tries at the exam.?
    Your table should be more like

    ExamStudentID (Autonumber)
    ExamID (FK)
    StudentID (FK)
    ExamScore
    ExamDate

    Then you just count the records for the number of attempts and Max(ExamDate) for relevant ExamStudentID
    Last edited by Welshgasman; 10-23-2020 at 10:11 AM. Reason: Amended structure

  3. #3
    ScottJ is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2020
    Posts
    2
    ok, thanks

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    In fact you will likely have multiple students for multiple exams, so that table will an intermediate table that joins students to exams.
    I've amended the layout for that table a little.

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

Similar Threads

  1. Show latest dates of each record
    By Behedwin in forum Queries
    Replies: 5
    Last Post: 12-15-2017, 01:36 AM
  2. only show results in report
    By EGTax in forum Reports
    Replies: 2
    Last Post: 09-29-2017, 12:30 PM
  3. Replies: 5
    Last Post: 08-31-2015, 01:03 PM
  4. Query to show latest records
    By Conceptz in forum Queries
    Replies: 3
    Last Post: 05-24-2012, 01:01 PM
  5. Limit query to only show the latest record
    By marcustofeles in forum Queries
    Replies: 12
    Last Post: 10-05-2011, 08:06 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