7,714
社区成员
发帖
与我相关
我的任务
分享
update SumStock set BuyPrice=
(select round(sum(StockCount*Costprice),3) from BuyLog where CodeID=BuyPrice.CodeID group by CodeID)
update SumStock set
buyprice=(round(Dsum('StockCount*Costprice','BuyLog','CodeID=SumStock.CodeID'),3))
update SumStock set
buyprice=(round(Dsum('StockCount*Costprice','BuyLog','CodeID='&SumStock.CodeID),3))