Calculated Fields Question

[smehaffie]

I need to use some calculated fields that changed based on values of other
fields.

TextBox Example:
If numMinimum < 199.00 Then numMinimum * .01
ElseIf numMinimum > 49.99 And numMinimum <= 199.00 Then 2.00
Else 1,00

CheckBox Example:
If chkOption1 is checked Then 1.00
Else 2.00

Any help on how to do this would be appreciated.

 

[smehaffie]

I was trying to do it entirely with fields, but can do it with VBA also. Can
you please post both ways and I will decide which way is better?

Thanks,