Finding a MAX value across columns.

  • Thread starter Thread starter DPCpresto
  • Start date Start date
D

DPCpresto

Is it possible within a query to find the MAXIMUM value across columns, such as using the MAX function in Excel? I am trying to design a database program to use in Powerlifing events, and I need to determine the maximum (highest) lift within each event. The following is an example of what I want to achieve...Thanks for all the help.


Athlete Lift1 Lift2 Lift3 (MaxLift...of 1,2,3)
Bob 235 245 260 260


DaveC
 
Is it possible within a query to find the MAXIMUM value across columns,
such as using the MAX function in Excel? I am trying to design a database
program to use in Powerlifing events, and I need to determine the maximum
(highest) lift within each event. The following is an example of what I
want to achieve...Thanks for all the help.


Athlete Lift1 Lift2 Lift3 (MaxLift...of 1,2,3)
Bob 235 245 260 260



Your data structure is incorrect. It should look like...

Athlete LiftNumber Weight
Bob 1 235
Bob 2 245
Bob 3 260

Then finding the Max weight is trivial (and you don't have to redesign your
application if the number of lifts per athlete changes at a later date).

Access is not a spreadsheet. If you try to use it as if it were you will
have no end to your frustration.
 
Back
Top