Finding top three values in six fields

[bbwolff]

I'm doing a medical db, where I'm trying to calculate ISS (

en.wikipedia.org/wiki/Injury_Severity_Score

).

There are 6 values, and i have to sum the largest three (squares to be precise). How can I get three highest values from 6 fields in the same record?


tx

 

[Galaxiom]

Sounds like you have a structure issue.

Those values should probably be held in one field in a related table with another field to indicate the what currently separates them into different fields. Then finding totals on the data is simple.

Otherwise use a Union query as a subquery to combine the fields into one then use TOP 3 in the main query.