Muzicmn969
Registered User.
- Local time
- Today, 18:48
- Joined
- Apr 4, 2002
- Messages
- 16
any ideas???
tasked with creating a new database for a school i came across this problem. Wanted to see if you guys had any ideas before i even begin creating this thing.
School has grades 1 thru 8. All students in all grades do not take the same amount of classes...thus my problem. How can i create a DB to track and average out student grades??? some kids in grade three might take 6 classes while others may take 7 or 8. So my deciding factor used to calculate my averages must be dynamic. Or in someway have Access query the student and add all the records and use that as a divider to get the average.....aaaahhhhh ! ! ! !
there must be an easier way
any ideas??
tasked with creating a new database for a school i came across this problem. Wanted to see if you guys had any ideas before i even begin creating this thing.
School has grades 1 thru 8. All students in all grades do not take the same amount of classes...thus my problem. How can i create a DB to track and average out student grades??? some kids in grade three might take 6 classes while others may take 7 or 8. So my deciding factor used to calculate my averages must be dynamic. Or in someway have Access query the student and add all the records and use that as a divider to get the average.....aaaahhhhh ! ! ! !
there must be an easier way
any ideas??