I have a test retest situation. I want to select the highest test score in the series of tests for each student for each student and get a difference score between the highest score and the initial. Then I want to select students that have a difference score greater than or equal to 5 points. I presently have an Access program that compares the students last test score with there initial score. I want to change this to use the students highest score from the field of test scores versus getting the most recent score diference. I have an active Student table with initial scores and Student progress table with the scores achieved at subsequent testing periods.My query selects all of the scores of each client. I want to select the highest. Sorry for the repition but I hope it helps clarity.Any suggestions? Thanks
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.