[AccessD] highest value of 4 variables - urgent

That's where I am with it too Rocky - until I get another solution I will go 
with this.....(but I'm sure there will be something that we both can't 
remember?)

Ta
----- Original Message ----- 
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Sunday, November 04, 2007 10:29 AM
Subject: Re: [AccessD] highest value of 4 variables - urgent


> Brute Force?
>
> Function GetHigh as Variant
>
> GetHigh = var1
> If var2 > GetHigh Then GetHigh = var2
> If var3 > GetHigh Then GetHigh = var3
> If var4 > GetHigh Then GetHigh = var4
>
> End Function
>
> I'm sure there's a more elegant way...
>
> Rocky
>
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
> Sent: Saturday, November 03, 2007 3:57 PM
> To: Access D Normal List
> Subject: [AccessD] highest value of 4 variables - urgent
>
> maybe i am having a vague moment - but what function can I use to get the
> highest value of 4 variables, eg:
>
>
> eg. I want to know x where x is the highest of (var1, var2, var3, var4)
>
> ta
> ______________________________________
> Kath Pelletti
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.503 / Virus Database: 269.15.19/1106 - Release Date: 
> 11/2/2007
> 9:46 PM
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>