Brian
Not sure if this is what you're after, but you could try it:
1 - in one single object for each different value in column A, add the text
you want in column B.
2 - SQL select where Column B <> "", grouped by column B, into query 1
3 - update column B in original table using data from query 1
In one line:
update mytable set X = B*(minimum(A,C)-C)/(A-C)+D*(minimum(A,C)-A)/(C-A)
If A=C, the record will not be updated. That should also be like
requested, but you get a division by 0 error.
Kind regards
Uffe Kousgaard
www.routeware.dk
- Original Message -
From: "Lathrop, Travis
Int() function has one undocumented feature - it can convert boolean
(logical) statements into integer values (returns 1 of TRUE, 0 if FALSE).
With use of it you can rewrite your code into something like this:
Update mytable set X = (Int(A
Jaromir Svasta
On Thu, 30 Oct 2003 16:44:20 +0100, Uff