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  VB6 and access 2007 sub queries statement

Author  Topic  byetoss Starting Member 2 Posts Posted - 2012-04-24 : 21:42:49 I have a vb6 project to generate semester transcript. However I want the second, third and forth semester to calculate the particular semester GPA and cummulative GPA. I was able to have the particular semester GPA but I could not nest the cummulative GPA within the same statement. My sample statement is as given below. I need urgent help from every body. AdoREP.RecordSource = "SELECT IND_NUM2, CCODE2, MARK, GRADE, CREDIT, G_POINT, T_POINT, COURSE.CTITLE, (T_POINT / CREDIT) AS CM FROM COURSE INNER JOIN ST_MARK ON ST_MARK.CCODE2 = COURSE.CCODE where IND_NUM2 = '" & ListS & "' and SEM_EXAM = '" & ComboS & "'" AdoREP.Refresh I need help from every body. BYE