Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  SEMESTER AND CUMMULATIVE SEMESTER RESULTS

Author  Topic  byetoss Starting Member 2 Posts Posted - 2012-04-29 : 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. BYE