Nov 16, 2001 #1 accessuserit Programmer Joined Nov 10, 2001 Messages 29 Location IT i need to store (in auto-mode) a calculated result in another field, for manipulate and save the data. Help me please! Paolo Chiesa
i need to store (in auto-mode) a calculated result in another field, for manipulate and save the data. Help me please! Paolo Chiesa
Nov 16, 2001 #2 rac2 Programmer Joined Apr 26, 2001 Messages 1,871 Location US Suppose calcY is the computed column and valueZ is the column which gets the static saved value as of some moment. Code: UPDATE ourTable SET valueZ = calcY will put the current value as data in valueZ for every row in ourTable. Any changed values will replace old values. Code: UPDATE ourTable SET valueZ = calcY WHERE valueZ IS NULL will put current values in valueZ but will not replace old values. Upvote 0 Downvote
Suppose calcY is the computed column and valueZ is the column which gets the static saved value as of some moment. Code: UPDATE ourTable SET valueZ = calcY will put the current value as data in valueZ for every row in ourTable. Any changed values will replace old values. Code: UPDATE ourTable SET valueZ = calcY WHERE valueZ IS NULL will put current values in valueZ but will not replace old values.