Didn't we have a field in the Countries Table (or elsewhere) that indicated whether a particular country charged an admin fee?
If this is the case (
see our previous thread), when we calculate the fees:
- Me.txtAdminFee = _
-
Format( _
-
IIf(Me.chkAdminFeeInitial, _
-
Me.txtInitialPremium * 0.015, _
-
0 )
-
), _
-
"Currency" _
-
)
Line 1: This is the text box where we want the admin fee to show up.
Lines 2, 7: You said you wanted it to appear as currency, so we use the Format() Function
Line 3: We check to see if this record has an Admin Fee (brought in from the Countries Table).
Line 4: If it does require an admin fee, then we calculate.
Line 5: If not, then the Admin Fee is 0.