G
Guest
I am trying to create a report that shows each student with their grade from each class (A,B+, etc) and their GPA. I am at a small school, (100 students, each taking the same 7 classes). I have a) student info table - name and ID number, b) a table that show each grade- based on student ID, but including year, semster, 6 weeks, subject, and c) a grade point table to convert the letter into a number
I have a crosstab query that shows each student with their grade from each class for a grading period. I would like my report to also include the GPA for that grading period. I have done some computer programming, but do not want to mess with macros, etc.
Do I need to create a query that shows each grade and then link the grade point table to also show the numeric grade equivalent. And then create a second crosstab query, this time using the numeric values and include average for total
My report would then use the first crosstab query, and add on the last field from my second crosstab
I thought about using my first crosstab query to create a simple query and then 'link' each grade to the numeric equivalent, and then creating a textbox in the report to average the invisible number grades. BUT I didn't think I could link my letter grades in my 3rd table to several fields in simple query
Any help/advice would be greatly appreciated
I have a crosstab query that shows each student with their grade from each class for a grading period. I would like my report to also include the GPA for that grading period. I have done some computer programming, but do not want to mess with macros, etc.
Do I need to create a query that shows each grade and then link the grade point table to also show the numeric grade equivalent. And then create a second crosstab query, this time using the numeric values and include average for total
My report would then use the first crosstab query, and add on the last field from my second crosstab
I thought about using my first crosstab query to create a simple query and then 'link' each grade to the numeric equivalent, and then creating a textbox in the report to average the invisible number grades. BUT I didn't think I could link my letter grades in my 3rd table to several fields in simple query
Any help/advice would be greatly appreciated