I am actually having another problem. I'm trying to do a report and in the
footer of StudentID I have an unbound text box to calculate the average grade
for each student. Here is the formula I'm using: =Avg(IsNumeric([Grade])).
It doesn't return the correct grade (-0.825), and it gives the same answer
for each student. Any thoughts? I know this is the Forms thread, so I can
move this question to the Reports if need be.

"John W. Vinson" wrote:

On Mon, 26 Apr 2010 07:04:04 -0700, Gntlhnds
wrote:

Man, this helped so much. This is what I started to try to do, but for some
reason I couldn't get the darn thing to work properly. Your step-by-step
instructions was just what I needed.

Glad to have been of help, and good luck with the database! Don't hesitate to
post back if you still have problems.
--

John W. Vinson [MVP]
.