sum of column 1 / sum of colum 2 (repost)

[wshm]

i am trying to fund a sum of c1 and
divide by sum of c2 to find 'estUnitCost'

maybe something like..

UPDATE tbl_EstUnitcost SET EstUnitcost
,sum(estcost)/sum(estprodunit) as estunitcost
FROM tbl_EstUnitCost
Group By tbl_EstUnitCost.DeptBudNo;

EstUnitCost should be sum of 'estcost divide by
sum of 'estprodunit'

i know the syntax is wrong.. but i think you
can get the idea of what i am thinking..
any help will be appreciated..

 

[wshm]

sigh.. just realized i don't need to do sum.
so all worked out now /w

UPDATE tbl_EstUnitcost SET tbl_estunitcost.estunitcost = ([estcost]/[estprodunit])

=)