Private Sub RoutA()
'创建责任清单
DoCmd.RunSQL "SELECT TabCostDuty.DuDWGC, TabCostDuty.ProID, TabCostDuty.DuNumber, TabCostDuty.DuPrice, [DuNumber]*[DuPrice] AS DuMoney, TabCostDuty.DuEnd, 0 AS PlanNumber, 0 AS PlanMoney, 0 AS ActualNumber, 0 AS ActualMoney INTO TabAll_listing FROM TabCostDuty;"
End Sub
Private Sub RoutB()
'创建计划清单
DoCmd.RunSQL "SELECT TabCostPlan.DuDWGC, TabCostPlan.ProID, TabCostPlan.PlanNumber, TabCostPlan.PlanPrice, [PlanPrice]*[PlanNumber] AS PlanMoney INTO TabAll_listing_plan FROM TabCostPlan WHERE (((TabCostPlan.PlanYes)=0));"
End Sub
Private Sub RoutC()
'创建计划汇总清单
DoCmd.RunSQL "SELECT TabAll_listing_plan.DuDWGC, TabAll_listing_plan.ProID, Sum(TabAll_listing_plan.PlanNumber) AS sumPlanNumber, Sum(TabAll_listing_plan.PlanMoney) AS sumPlanMoney INTO TabAll_plan FROM TabAll_listing_plan GROUP BY TabAll_listing_plan.DuDWGC, TabAll_listing_plan.ProID;"
End Sub
Private Sub RoutD()
'更新责任清单_计划
……
end sub
唐小小,你说你破了,请你把RoutD这个子程序贴上来好吗?你好厉害!
能破的人总是不说话,不会的人总是说会,唉!
千万别告诉大家你不会发帖了啊:)
[此贴子已经被作者于2003-6-19 11:00:27编辑过]
|