Guys,
I figured it out… the conditions weren’t being defined well enough for the ‘between’ values. Here are the changes I made to the If…Then… Else statements:
If dOrderTotal >= 500 Then
dDiscountPct = 0.2
ElseIf dOrderTotal >= 250 And dOrderTotal < 500 Then
dDiscountPct = 0.15
ElseIf dOrderTotal >= 100 And dOrderTotal < 250 Then
dDiscountPct = 0.1
Else ‘(dDiscountPct < 100)
dDiscountPct = 0
End If
I appreciate all of your assistance – you guys got me to thinking a little more clearly.
Ruth
Discuss This Question: 6  Replies