max function (1 Viewer)

R

rsanders

Guest
This is a repost. Sorry. If this is a stupid question, someone let me know, and I'll drop it. Thanks in advance.
Really simple question. How do you designate a field to automatically display the maximum value of several fields on that same form? I know you can return max value for individual field from all the records, but I just want max value for several fields on one record. Thanks.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 11:12
Joined
Feb 19, 2002
Messages
42,970
There is no built in function that does this. You can code your own function and use it in a query. Pass it the fields you want to compare and have it return the maximum value. You will not be able to tell which field supplied the max value. If that is also important, you will need 2 functions. One to return the value and one to return the field that supplied the value.
 

Users who are viewing this thread

Top Bottom