"hi
first of all,thanx for your time
i build up a database for students in a college %26 i need to calculate the GPA for each one depend on this formula
GPA=[(points*no. of cridet hr. for course)+(points*no. of cridet hr. for course)+(points*no. of cridet hr. for course)+.....]/(total no. of hrs.)
points:A=4/B+=3.5/B=3/C+=2.5/C=2/D+=1.5/D=1/F=0
i have 4 tables in the database
students:studentId(pk)-studeNtname
enrolment:studentId(pk)-courseId-grade
courses:courseId(pk)-courseName-hours
gpa:studentId(pk)-gpa
what will be the formula in access and in where shall i put it?
i appreciate your help
thanx a lot"
first of all,thanx for your time
i build up a database for students in a college %26 i need to calculate the GPA for each one depend on this formula
GPA=[(points*no. of cridet hr. for course)+(points*no. of cridet hr. for course)+(points*no. of cridet hr. for course)+.....]/(total no. of hrs.)
points:A=4/B+=3.5/B=3/C+=2.5/C=2/D+=1.5/D=1/F=0
i have 4 tables in the database
students:studentId(pk)-studeNtname
enrolment:studentId(pk)-courseId-grade
courses:courseId(pk)-courseName-hours
gpa:studentId(pk)-gpa
what will be the formula in access and in where shall i put it?
i appreciate your help
thanx a lot"