Recent content by bremersj

Ahh...perfect. Thank you!

Is there a way to retrieve the value of a user-defined type in a query? Here's the type: Public Type ClassRank Rank As Integer ClassCount As Integer End Type I have a function with the following excerpt: Function GetRank(strDOD) as ClassRank ... GetRank.Rank = intRank...

Thanks for the response! That's what I suspected. I made a complicated set of nested queries to get the numbers I wanted. Perhaps I should go with your simpler solution, though.

I'm having a problem getting a report textbox to display the average value that I want. Background: I have a DB that tracks student grades. The course is organized into blocks, with several tests in each block. Students can take the same test multiple times, in cases of failure, or if they get...