Max value function

  • Thread starter Thread starter dan_johnson
  • Start date Start date
D

dan_johnson

I am trying to find the largest value from 15 different fields. The data
structure is such that similar values are being input into these fields
complicating the extraction of the data needed. Is it possible to use the
Max function to obtain the highest value?
 
The Max() function in Access Totals queries applies to a single field, not
across multiple fields. If you have the same kind of value(s) in more than
one field, your data structure may need more normalizing to take full
advantage of the strengths Access offers.

If you have 15 fields with like values (all measuring the same thing), you
have a spreadsheet. Access is a relational database, and you need to use it
differently than you would a spreadsheet.
 
Sort the value in "descending" order and group by "last" in your quer

----- (e-mail address removed) wrote: ----

I am trying to find the largest value from 15 different fields. The dat
structure is such that similar values are being input into these field
complicating the extraction of the data needed. Is it possible to use th
Max function to obtain the highest value
 
Back
Top