Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Location
    Orlando, Florida, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Table Validation If Statements (2000)

    I have a table that has a DeliveryDate field and a DeliveryMemo field and I am trying to create a Table level validation rule that will require a DeliveryMemo if a DeliveryDate is populated. I have tried using an If Statement but can't seen to make it work. Any ideas? <img src=/S/question.gif border=0 alt=question width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Table Validation If Statements (2000)

    You can use the function IIf (Immediate If) in expressions. The general form is

    IIf(Condition, Result_if_True, Result_if_False)

    In your table, use this:

    IIf(Not IsNull([DeliveryDate]), Not IsNull([DeliveryMemo]), True)

    If the DeliveryDate is populated (not Null), test if DeliveryMemo is populated (not Null), otherwise it's always OK.

  3. #3
    New Lounger
    Join Date
    Feb 2003
    Location
    Orlando, Florida, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table Validation If Statements (2000)

    That worked perfectly! Thanks tons!!
    Jill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •