printing trend symbols

Hello,
A report prints a students grades over time.
For example, a few rows might read:
English Exam 7/25/03 A-
French Exam 6/20/03 B+
Trig Exam 5/21/03 A

The data comes from a query where the exam
results are sorted by date. What I want to do
is start from the first exam and indicate better or worse.
For example:
English Exam 7/25/03 A- up
French Exam 6/20/03 B+ down
Trig Exam 5/21/03 A

of course, I will change the up/down to arrows. Any
thoughts on how to implement this?

Scott

Scott M wrote:
A report prints a students grades over time.
For example, a few rows might read:
English Exam 7/25/03 A-
French Exam 6/20/03 B+
Trig Exam 5/21/03 A

The data comes from a query where the exam
results are sorted by date. What I want to do
is start from the first exam and indicate better or worse.
For example:
English Exam 7/25/03 A- up
French Exam 6/20/03 B+ down
Trig Exam 5/21/03 A

of course, I will change the up/down to arrows.


Well, I think this a really silly thing to do. If anyone
ever bothered to look at my language grades vs my math
grades, it would look like a yo-yo.

Ok, regardless of what I think, you can do this by using a
couple of Domain Aggregate functions to find the previous
grade.

DLookup("grade", "thequery", "studentID = " & studentID &
" And examdate = " & DMax("examdate", "thequery",
"studentID = " & studentID & " And examdate " &
Format(examdate, "\#m\/d\/yyyy\#")))

--
Marsh
MVP [MS Access]