Software

Ask something
Discussion Locked

Ranking

0 helpful
1 reply

by bbbnews

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am designing a db for students' grades reporting. Within this db there is a calculated textbox for the overall average of each student. What should I do to get the students ranked according to this overall average?

Many thanks.

1 reply

by cptomlly

Its a general DB design no-no to save calculated values within your data tables. Calculations should be done with a report or query. Your desired rankings would then just be a matter of sorting the results.

This discussion is closed to new replies.