Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    173

    Unanswered: finding max of 3 fields

    As three different fields change on a form I'd like a 4th field to always equal the highest of the other three. Would I use an if then statement or is there some "max" function I can use?

  2. #2
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Re: finding max of 3 fields

    Originally posted by leeroy
    As three different fields change on a form I'd like a 4th field to always equal the highest of the other three. Would I use an if then statement or is there some "max" function I can use?
    you would have to use an if then function to evalueate the three fiields, id even use and iif statment to make it simpiler

    iif(field1 > field2 and field1 > field3, textbox=field1, iif(field2 > field1 and field2 > field3, textbox=field2,iif(field3 > field1 and field3 > field2, textbox = field3)))

    something similure to that should do the trick
    Jim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •