funderburgh
Registered User.
- Local time
- Today, 04:15
- Joined
- Jun 25, 2008
- Messages
- 118
I need "Big Picture" help.
My application will generate report cards for the students at my school (it is already handling all of the scheduling). Each "class" (i.e. Algebra) has four quarterly grades.
The grade fields start out as null, because any number (like zero) could be a grade.
When I create a recordset for the report card report, I have to calculate a GPA, and I don't know which grades will be null, for example the report card report could be being run at the end of the first quarter, or the student could have started in the middle of the year.
Is there a way to attach VBA code to a query? I could certainly use conditional code and the presence of null values to calculate the GPA correctly, but the query builder, can't be sufficiently tuned to recognize if the data should be averaged by 2, or 4 nor not at all.
I am grateful for any ideas/help.
My application will generate report cards for the students at my school (it is already handling all of the scheduling). Each "class" (i.e. Algebra) has four quarterly grades.
The grade fields start out as null, because any number (like zero) could be a grade.
When I create a recordset for the report card report, I have to calculate a GPA, and I don't know which grades will be null, for example the report card report could be being run at the end of the first quarter, or the student could have started in the middle of the year.
Is there a way to attach VBA code to a query? I could certainly use conditional code and the presence of null values to calculate the GPA correctly, but the query builder, can't be sufficiently tuned to recognize if the data should be averaged by 2, or 4 nor not at all.
I am grateful for any ideas/help.
