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.
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!