Posted - 04/29/2012 : 09:36:29
| I have two tables MARKS and COURSES with CCOODE as common ID among the two tables.
In MARKS I have score, credit, T_point, Grade, G_Point, CCODE2
In COURSE I have Ctitle, CCODE
I want an sql statement that will display Scores, Grade, credit, T_point, ctitle in the body of the report.
I also want to display two summaries at the bottom of each semester report. (This is where my problem begins)
1. To display (sum of T_Point / Sum of credit)as 2nd semester GPA
2. To display cummulaties(sum of T_Point / Sum of credit)as 1st and 2nd semesters combined GPA.
I am using vb6 and MS access 2007. I need your help urgently.