Help with simple code answer, please

[Angyl]

How do I attach a simple code to a form field that says "IF" (FieldX) is
GREATER or LESS THAN (FieldY), Then (FieldZ) =(FieldX)+(FieldY)"

I'm making a form that has to add, multiply and subtract different fields.
But I want some fields to operate only under certain circumstances.

The code I'm using is simplistic but I'm missing one key piece. An example
of what I'm currently attaching to fields doing looks like this:

=(PremiumTotal)*.95

That works fine. Or

=(PremiumTotal)*(LLimit)

That works fine too.

How do I tell a field to calculate ONLY IF X Field is greater than or less
than Y Field?

I've tried playing around with it myself but can't get the syntax right.

(IF) (PremiumTotal)<>(Emod) =(PremiumTotal)+(Emod)

Thanks for your help!!

 

[Charles Kenyon]

Are you trying to do this in visual basic for applications or in a document?
Look up the IF field in Word help if the latter.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide




--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.