1. I am developing a student transcript report that will show a student's grades in each of 4 subjects for each quarter of reporting.
2. In addition a.) the report has to show the average GPA across all 4 subjects for each quarter; b.) it also has to show the average GPA for each subject across all 4 quarters.
3. My table is designed so that each record contains a unique student ID number; a unique subject code for each of the four subjects; and a letter grade (with a lookup numerical value) for each of the four marking periods. Therefore, each student has four records in the table.
4. I want to base the report on a query that will call a function to a.) loop through each ID and subject code for a given marking period and return an average GPA for each that quarter; and create another one to b.) that will generate an average GPA for each subject across each of the four quarters.
5. What is the most efficient looping procedure to use???????
Your help will be of great assistance.
chatfield
2. In addition a.) the report has to show the average GPA across all 4 subjects for each quarter; b.) it also has to show the average GPA for each subject across all 4 quarters.
3. My table is designed so that each record contains a unique student ID number; a unique subject code for each of the four subjects; and a letter grade (with a lookup numerical value) for each of the four marking periods. Therefore, each student has four records in the table.
4. I want to base the report on a query that will call a function to a.) loop through each ID and subject code for a given marking period and return an average GPA for each that quarter; and create another one to b.) that will generate an average GPA for each subject across each of the four quarters.
5. What is the most efficient looping procedure to use???????
Your help will be of great assistance.
chatfield
