Maximum value from different fields of the same record

[Vandana Rola]

Hi,

I am trying to write a query that will find minimum/maximum value from
different fields of the same record. e.g. if students have taken three
tests, we want to drop the lowest score of each student and get two
highest scores.

Thanks

 

[Wayne Morgan]

The test scores should be in a separate table linked back to the students
table by the student ID. Include other relevant data to the test, such as
the test date. Once you do this, all the test scores will be in the same
field and you can find the min and max.