dbTalk Databases Forums  

update query that selects the column with the highest value

comp.database.ms-access comp.database.ms-access


Discuss update query that selects the column with the highest value in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Joshua Zarr
 
Posts: n/a

Default 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

Reply With Quote
  #2  
Old   
Johnny Meredith
 
Posts: n/a

Default Re: update query that selects the column with the highest value - 12-11-2003 , 04:48 PM






I think you will have to use VBA for that (not sure a query can
'choose' a particular field based on logic by itself). Before I go
on, are you comfortable with VBA?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.