UPDATE Post #3: Ok so I found your code and I'm going through it and I see:
Code:
iPartID = cboPart
cBaseCost = BaseCost
cAmorAmt = AmorAmt
iAmorMin = AmorMin
iAmorMax = AmorMax
cGroupAmt = AmorDiff
iMax = iAmorMax
cCostMatch = (cAmorAmt / iAmorMax) + cBaseCost + cGroupAmt
db.Execute ("DELETE * FROM tblAmoritize WHERE Item_ID = " & iPartID)
Do While iAmorMax >= iAmorMin
cAmorCost = (cAmorAmt / iAmorMax) + cBaseCost
'Debug.Print iAmorMax & " " & Format(cAmorCost, "$#,##0.0000")
If cAmorCost <= cCostMatch Then
Else
iMin = iAmorMax
If iAmorMax <> iAmorMin Then
db.Execute ("INSERT INTO tblAmoritize (Item_ID, Item_LB, Item_UB, Item_Amor_Amt) VALUES (" & iPartID & ", " & iMin & ", " & iMax & ", " & cCostMatch & ")")
'Debug.Print " " & iAmorMax & " " & Format(cAmorCost, "$#,##0.0000") & " " & Format(cCostMatch, "$#,##0.0000") & " " & iMin & " " & iMax
Else
GoTo EXITLOOP
End If
So your calculations take the amortize amount over the maximum, when I need it to take the amount over the current quantity. Do I need to create another variable to keep track of the current quantity count?