Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Sat Nov 3 18:29:56 CDT 2007
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