Nov 28, 2001 #1 mcginty IS-IT--Management Mar 14, 2001 35 IE Hi All, I have two quickies.. 1. How do I update a value in a field to 1.5 times it's own value? 2. How do I update a value to the value of another field? Rgds, Ted
Hi All, I have two quickies.. 1. How do I update a value in a field to 1.5 times it's own value? 2. How do I update a value to the value of another field? Rgds, Ted
Nov 28, 2001 #2 ramani Programmer Mar 15, 2001 4,336 AE HI 1. How do I update a value in a field to 1.5 times it's own value? REPLACE ALL myField WITH 1.5*myField 2. How do I update a value to the value of another field? REPLACE ALL myField WITH myFildAnother ... assumed the fields are in the same table. ramani :-9 (Subramanian.G),FoxAcc, ramani_g@yahoo.com Upvote 0 Downvote
HI 1. How do I update a value in a field to 1.5 times it's own value? REPLACE ALL myField WITH 1.5*myField 2. How do I update a value to the value of another field? REPLACE ALL myField WITH myFildAnother ... assumed the fields are in the same table. ramani :-9 (Subramanian.G),FoxAcc, ramani_g@yahoo.com
Nov 28, 2001 Thread starter #3 mcginty IS-IT--Management Mar 14, 2001 35 IE Thanks Ramani Upvote 0 Downvote