[已解决]大家帮我看看出库单的问题
[已解决]大家帮我看看出库单的问题
每张单子的总价。 这张应该是4960,怎么会是6860。还有一个总价存放位置的难题。望赐教!!! 好了。谢谢FookYou哥。 Sub 保存() Dim mydb As Database Dim Rs As DAO.Recordset Dim Arr, i%, j% Arr = Range("A5:H9") Set mydb = OpenDatabase("d:\出库单汇总\出库单汇总.mdb") Set Rs = mydb.OpenRecordset(Name:="出库单汇总", Type:=dbOpenDynaset) For i = 1 To 5 If Arr(i, 1) <> "" Then Rs.AddNew Rs.Fields(0) = [H2] Rs.Fields(1) = [H3] Rs.Fields(2) = [B3] For j = 3 To 10 Rs.Fields(j) = Arr(i, j - 2) Next 'Rs.Fields(11) = Rs.Fields(9) * Rs.Fields(10) Rs.Update End If Next Rs.AddNew Rs.Fields(0) = "总价:" Rs.Fields(10) = [H5] + [H6] + [H7] + [H8] + [H9] Rs.Update MsgBox "数据保存完毕!" Rs.Close mydb.Close End Sub
[此贴子已经被作者于2010-3-29 18:49:32编辑过] |