Validation Rule for one field, if the other has a yes or no box

[bambi_no89]

Hey all


first of all: i use the german office 2013, so some of the terms are roughly translated by myself, but i hope you can figure out my problem.

The Task:
The Database is about a library. Some customers are eligible for an extended rental period
In my Table one column is named "Extension" which is supposed to be a yes or no checkbox.
Another column is named "Amount" for the amount of days the extension lasts

Now i am supposed to place a validation rule with the following aspects:
If the box @"extension" is marked YES , a value from 1 to 30 MUST be entered @"amount"
If the box @"extension" is marked NO , no value is allowed/supposed to be entered @"amount"

All the tries i did so far resulted in different errors (syntax errors or else)

The closest i got so far:

([extension]="yes" AND [amount]>=1 AND <=30) OR ([extension]="no" AND [amount]=0)


any ideas?
thanks a lot

[CJ_London]

a checkbox has a Boolean datatype - -1/0, true/false or yes/no (no quotes). and you cannot use >= and <= as you have

so try

([extension]=true AND [amount]>=1 AND [amount]<=30) OR ([extension]=false AND [amount]=0)

[bambi_no89]

It works, finally ^^
Thank you