Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    SF - California
    Posts
    2

    Question Unanswered: Validation Rules - Dates

    In MS Access, I'm trying to set a validation rule that restricts entering a "Trip_Date" that is before the "Order_Date". This seems like it should be easy, but nothing seems to work. Logically, it should look like this: [Trip_Date] >= [Order_Date]. And of course if a wrong date is entered, then an error message appears (I can handle that part though). Any help would be greatly appreciated. Thanks.

  2. #2
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346

    Re: Validation Rules - Dates

    Try surrounding the dates with number signs i.e.

    #Trip_Date# >= #Order_Date#

    This tells access that it is dealing with dates.
    http://www.scirocco.ca/images/banner...occobanner.gif

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

  3. #3
    Join Date
    Mar 2004
    Location
    SF - California
    Posts
    2

    Re: Validation Rules - Dates

    Yeah, I tried that but it didn't work. Thanks though.


    Originally posted by SCIROCCO
    Try surrounding the dates with number signs i.e.

    #Trip_Date# >= #Order_Date#

    This tells access that it is dealing with dates.

Posting Permissions

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