[AccessD] Re Max of 20 values

Exactly!  Since you have a fixed set of controls it's write once and walk
away.  And you have a MaxOfVars function for future use.

Null values are ignored.

Good Luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Saturday, July 23, 2011 10:45 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Re Max of 20 values

If I understand what you are saying, I ought to create an array consisting
of M1...M29 and pass it to said function, and let the function walk through
the array to determine the max value. Is that right?

Thx.
Arthur

On Sat, Jul 23, 2011 at 11:35 AM, Dan Waters <df.waters at comcast.net> wrote:

> Hi Arthur,
>
> I found this function in my library file.  This uses a parameter array 
> and just loops through looking for the highest one.
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com