Access question [Archive] - SpeedGuide.net Broadband Community

View Full Version : Access question


fatboy95
08-07-02, 10:25 AM
I have a database that tracks student test scores and need to get a student total percentage, test total percentage, and class total percentage.

It has to be done all automatically due to computer illiterate people I work with. Is there a way to do this with access

IE;
Test 1 Test 2 Student Total
Student 1 100 100 100%
Student 2 90 90 90%
Test Total 98% 98% 98%


Something like the above, I know this is done easily in Excel, but I wanted to be able to just put the student score into an Access database and let it do the rest for me.

Thanks ahead of time for the help.