Good thinking Lou; that did the trick.

I live in the Orland Park area -- SW suburbs -- spittin' distance from a couple of OTBs. LOL

Used to make the trip to AP but traffic usually sucked on the way home on 53/290/294.

Good luck.

I'm going to bump this topic up because I'm missing something. Is it possible to get the higher value from either of two columns into a third? How would I do it? This doesn't work: #GREATER(#COLVAL(1), #COLVAL(2)).

Figured it out.

(#GREATER(#COLVAL(5), #COLVAL(6))*#COLVAL(5))+(#GREATER(#COLVAL(6), #COLVAL(5))*#COLVAL(6))

Bill,

There may be an easier way using VBScript functions.

There's a "max" funcion in C that takes two params and returns the maximum value.

max(#COLVAL(x), #COLVAL(y))

would give you what you want -- if the VBScript function exists and you can find the correct syntax.

Bill,

#GREATER(#COLVAL(1), #COLVAL(2)) * #COLVAL(1) +
#GREATER(#COLVAL(2), #COLVAL(1)) * #COLVAL(2) +
#EQUAL(#COLVAL(1), #COLVAL(2), .00001) * #COLVAL(1)

Also covers you if the two cols are equal

Don't know about Max - I'll look it up and try it...

Lou

Whoops - need to parenthesize each sub-expression, but you get the idea

Re: Max

Nope, no Max function in VBScript docs - there's a MaxValue parameter for limiting the value of variables but that doesn't apply for what you want to do...

If that's the case I will add a Max/Min that returns the max, or min, value given to it (the function).

Thanks for the heads up Lou

#EQUAL(#COLVAL(1), #COLVAL(2), .00001) * #COLVAL(1)

Bill N