Unanswered: Filtering a report to show students who failed most recent exam plus 1 previous exam
I have created a table with exam codes (these are based off consecutive date numbers, ie "Exam20151021" for the exam on October 21, 2015) for each exam session, followed by student ID number and the score. Tables were also made containing the student names matching the ID number and the dates of the exams matching the exam code. I created a query to gather the information from these tables and produce reports.
I am trying to use the same report but have it be filtered to only present names of students matching certain criteria.
If the score for the most recent exam (ie, the maximum exam code) is at or below 69 AND the student has scored at or below 69 on any ONE previous exam, the student needs to show up in the At Risk Report.
If the score for the most recent exam is at or below 69 AND the student has scored at or below 69 on any TWO previous exams, they need to show up in the Academic Board Report.
How would I code this? Would I enter it on the filter settings in my query, or somewhere else?
Create the two Query to find the outcomes then Union them
as you go to print them
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.