From: Scott W. <swa...@my...> - 2002-10-23 19:02:48
|
On Wed, 23 Oct 2002, mowestusa wrote: > I've created a simple database to keep track of grades > for students. > > It has the following fields: > Name Type > =========================== > Date Date > Assignment String > Total Points Integer > Student1 #wrong Float > Student1 grade Calculated > Student2 #wrong Float > Student2 grade Calculated > Student3 #wrong Float > Student3 grade Calculated > > I simply want 100 - ((100 divided by "total > points")* "Student1 #wrong") > Student 1 grade = (- 100 (* (/ 100 %2) %3)) Student 2 grade = (- 100 (* (/ 100 %2) %5)) and so on... does that work? -Scott |