[AccessD] highest value of 4 variables - urgent

    That is cute Andy!  My compliments for such elegant solution.

A.D.Tejpal
------------

  ----- Original Message ----- 
  From: Andy Lacey 
  To: 'Access Developers discussion and problem solving' 
  Sent: Sunday, November 04, 2007 13:34
  Subject: Re: [AccessD] highest value of 4 variables - urgent


  If you write yourself a general purpose Max function along the lines of

  Function Max(var1, var2)

  If var1>var2 then
    Max=var1
  Else
    Max=var2
  End if
  End Function

  then you can just

  Result=Max(Max(Max(var4,var3),var2),var1)

  -- Andy Lacey
  http://www.minstersystems.co.uk