Greetings Everyone...
Not sure why this IIf is calculating the 'False' part
Here is how it is written:
Me.CmbDept does equal "Store Discount" and thus I'm looking for the return of 100% in the PctSavings control and the subsequent table field nameCode:PctSavings = IIf(Me.CmbDept = "Store Discount", 1, (TtlSavings / Me.TxtRegPriceTtl))
however the formula is blowing past the True part and calculating the false part and giving a Div/0 Error. (The values of TtlSavings & Me.TxtRegPriceTtl are $7.50 and 0 respectively)
Looking forward to reading is staring me right in the face but I'm just too blind to see it...
Thank You All ~
RT91