Validating tables with the use IF Statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am designing a expenses database where basically one expense can either
only have a value (i.e. currency) or business miles amount (i.e an amount of
miles inccured on a claim).

This data is entered into fields ExpensesItemsPrice and BusinessMilesIncurred

I want to be able to ensure that a user must not leave these fields blank
but if they enter a value in BusinessMilesIncurred they do not have to enter
a value into BusinessMilesIncurred and Vica Versa.

Thanks Stew
 
Set a validation rule on the table:

1. Open your table in design view.

2. Open the Properties box (View menu).

3. Beside the Validation Rule in the Properties box (not the one in the
lower pane of table design), enter:
([ExpensesItemsPrice] Is Not Null) Or ([BusinessMilesIncurred] Is Not Null)
 
Back
Top