Finding the Max (1 Viewer)

[juliebme]

Need to find the max of 3 fields in **ONE RECORD**...

You have one record with say 4 fields:

Measurement1
Measurement2
Measurement3
Measurement4

So the data would look like this:

Ms1 -- Ms2 -- Ms3 -- Ms4
22 -- 8 -- 6 -- 10 Max of Measurements 2 through 4 = 10
18 -- 6 -- 15 -- 2 Max of Measurements 2 through 4 = 15


For each record, I need to find the max of Measurements 2 through 4. I know how to do this for one field & many records. Just not sure how to do this with one record & 3 fields.

Note...I am working in a query.

Thanks for any help in advance!

Julie

 

[Rich]

I'd say you have a db design/structure problem. You only need two fields Measurement and Measurement type plus any other fields that go with the data. If you re-structure the db extracting data the way you want is much easier. You seem to be entering data in a spreasheet type format at the moment.
HTH