G
Guest
I posted this and got no respnonse so I thought I'd try again...
I have a query based on a table that contains the following fields -StuID,
StuName, GradeLevel, TestDate, and TestScore(each date has a corresponding
score).
A student may have anywhere from 2 to 8 records and the dates vary from
student to student. I need a series of queries that will allow me to get the
2 most recent test dates and corresponding scores for each student and find
the difference in the 2 scores.
Thanks for the assistance.
I have a query based on a table that contains the following fields -StuID,
StuName, GradeLevel, TestDate, and TestScore(each date has a corresponding
score).
A student may have anywhere from 2 to 8 records and the dates vary from
student to student. I need a series of queries that will allow me to get the
2 most recent test dates and corresponding scores for each student and find
the difference in the 2 scores.
Thanks for the assistance.