Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder
    Join Date
    Mar 2006
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Validation Rule value

    Hello,
    I am trying to make a validation rule which says: the joindate value must be before the expirationdate.

    I made this rule:>=[JoinDate] And <[ExpirationDate] but access does not like it.


    JoinDate and ExpirationDate are names of columns in my table.


    Thanks for your help!

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    Please post in the correct forum, you are using Access and not MySQL but posting in the MySQL forum. you need to post in the other database area. Thread is moved.

  • #3
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,537
    Thanks
    77
    Thanked 4,381 Times in 4,346 Posts
    ... WHERE JoinDate < ExpirationDate ...

    No idea why you thought you wanted either >= or AND in there.

    And this is still in the wrong forum, you know. A moderator will undoubtedly move it.

    ************

    EDIT: How's that for making a prediction that has already come true? <grin/>


  •  

    Posting Permissions

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