division on two columns, update same table

[dharkangel]

Is something like this possible? (I know this is not the proper syntax, but this is the idea I have)

UPDATE Table1 SET EUM_Avg = (SELECT (EUM/EUM_Total) AS myAvg FROM Table1) WHERE Table1.ID = 1;

 

[PHV]

Why storing derived/calculated values ?
Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886