Get higest value from a group of fields.

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

Guest

Is it possible to pull the highest value from a group of 4 fields in a form?
Example:

Field1 Field2 Field3 Field4 Returned Value
1 4 4 6 6
2 7 8 2 8

Thank you,

Fred
 
If your table is storing similar values across columns, you have ... a
spreadsheet! Is there a reason you don't find the maximum of those values
using a spreadsheet?

If you want to get the best use of the excellent features and functions that
Access (a relational database) offers, you'll need to modify your data to
fit a well-normalized table structure.

Access offers a Totals query, including a Maximum function, but it only
works "vertically", not, as the example you gave shows, "horizontally".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top