Average for Date Range

[Adam M.]

I've set up a database for calculating a student's grade for a class. What I want to be able to do is to calculate the student's average for a date range. How do I do this?

[sbg2]

In Preveiw Mode (Report) or Browse Mode?

[mr_vodka]

If you have a summary field for averages, then all you have to do is perform a specific find for the date range for that particular student.

In other words, do a date range find either manually or scripted, and the average summary field should reflect the current found set.

[Adam M.]

I'm need to do it in browse mode and report mode. I didn't create a summary field to calculate the average initially. I have a join table between Students and Classes called Enrollment. The Class has Assignments. Assignments is related to Results. I have a second occurence of Results related to Enrollments. The average is calculated in the Enrollment table. Is this the wrong way to do this?

[Adam M.]

I got a summary field in the results table. How do I use the date range?