Hello and thanks in advance for the help.
My end result is to punch in a given date and starting at that date up to current day, sum all exams taken, re-exams taken and giving me a percentage of overall failures as compared to total quantity of tests.
I have several fields for a class and exams where multiple exams could be taken on the same day.
The fields are:
Class
StudentName
DateofExam
NumberofExamsTaken
NumberofExamsFailed
ReExamsTaken
ReExamsFailed
OverallFail%
Currently, my query is created to ask what the start date is and what the student’s name is. It then retrieves this data and sums the numbers up for fields of exams taken, exams failed, re-exams taken and re-exams failed. I then have it perform simple percentage calculation and display the result. My problem is that since each exam is a different day, the results instead of coming out on a single result looking like:
Name / Exams taken / Exams Failed / Re-Ex taken / Re-Ex failed / Overall %
I get the above data for each dated entry such as:
Name / Exams taken / Exams Failed / Re-Ex taken / Re-Ex failed / Overall % / 01-Jan-09
Name / Exams taken / Exams Failed / Re-Ex taken / Re-Ex failed / Overall % / 15-Jan-09
Name / Exams taken / Exams Failed / Re-Ex taken / Re-Ex failed / Overall % / 28-Jan-09
Name / Exams taken / Exams Failed / Re-Ex taken / Re-Ex failed / Overall % / 04-Feb-09
I also get the same result if I uncheck the show date column just no dates are displayed.
This worked beautifully until I added the start date parameter and now I am stuck.
I am sure this is simple but I am currently at a mental block and am banging my head on the desk, so if you have any suggestions please let me know. Thanks again for your time.
My end result is to punch in a given date and starting at that date up to current day, sum all exams taken, re-exams taken and giving me a percentage of overall failures as compared to total quantity of tests.
I have several fields for a class and exams where multiple exams could be taken on the same day.
The fields are:
Class
StudentName
DateofExam
NumberofExamsTaken
NumberofExamsFailed
ReExamsTaken
ReExamsFailed
OverallFail%
Currently, my query is created to ask what the start date is and what the student’s name is. It then retrieves this data and sums the numbers up for fields of exams taken, exams failed, re-exams taken and re-exams failed. I then have it perform simple percentage calculation and display the result. My problem is that since each exam is a different day, the results instead of coming out on a single result looking like:
Name / Exams taken / Exams Failed / Re-Ex taken / Re-Ex failed / Overall %
I get the above data for each dated entry such as:
Name / Exams taken / Exams Failed / Re-Ex taken / Re-Ex failed / Overall % / 01-Jan-09
Name / Exams taken / Exams Failed / Re-Ex taken / Re-Ex failed / Overall % / 15-Jan-09
Name / Exams taken / Exams Failed / Re-Ex taken / Re-Ex failed / Overall % / 28-Jan-09
Name / Exams taken / Exams Failed / Re-Ex taken / Re-Ex failed / Overall % / 04-Feb-09
I also get the same result if I uncheck the show date column just no dates are displayed.
This worked beautifully until I added the start date parameter and now I am stuck.
I am sure this is simple but I am currently at a mental block and am banging my head on the desk, so if you have any suggestions please let me know. Thanks again for your time.
