update query that selects the column with the highest value -
12-05-2003
, 05:24 PM
Im looking for instruction for creating an update query that will
choose the name of the column that has the highest value. For example
if i had a record with three columns called thing1, thing2, and
thing3. The query would store the name of the column that had the
highest value into a new column. Assume the the thing1,2 and 3 colums
are integers and the column to be stored in is a text field.
Any help would be greatly appreciated.
Thanks,
Joshua Zarr |