VALIDATION FORM "HELP"

[Lorena via OfficeKB.com]

I created a form that needs some validation.

I got two fields [Received%]-the value is decimal &[Amount-the value is
currency- I need to get a formula that if the received percent is blank the
amount is required field and vise verse.(If the amount field is blank the
received percent is required.

PLEASE HELP ME....PLEASE HELP ME....PLEASE HELP ME....

Much appreciated.

Lore

 

[Sue Mosher [MVP-Outlook]]

A validation formula must return True if the data is "good" and False if the
data is "bad." Since you are working with numeric fields, blank may not
really an option. Outlook probably will eventually force it to zero, but we
can try using Null.

When you have two fields that are dependent in this way, I find that it
helps to work through the logic of what's good and what's bad. Can you
confirm that these are the "good" scenarios:

[Received%] Is Null
AND [Amount] > 0

or

[Amount] Is Null
AND [Received%] > 0

What about this one:

[Amount] > 0
AND [Receive%] >0