Find the maximum value in a range of fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to find the highest numeric value in a range of fields all in the same
table and include the extracted value in a field in the query.
 
In general, searching across fields horizontally indicates that you use one
field in a related table (many related records, instead of many fields in
one record).

If you need to do it anyway, see:
MinOfList() and MaxOfList()
at:
http://members.iinet.net.au/~allenbrowne/func-09.html
To use function, you will end up typing something like this into the Field
row of your query:
MaxOfList([Field1], [Field2], [Field3], [Field4])
 
Allen Browne said:
In general, searching across fields horizontally indicates that you use one
field in a related table (many related records, instead of many fields in
one record).

If you need to do it anyway, see:
MinOfList() and MaxOfList()
at:
http://members.iinet.net.au/~allenbrowne/func-09.html
To use function, you will end up typing something like this into the Field
row of your query:
MaxOfList([Field1], [Field2], [Field3], [Field4])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

gburnett said:
I need to find the highest numeric value in a range of fields all in the
same
table and include the extracted value in a field in the query.
Click to expand...
Click to expand...
 
Back
Top