I'm creating a database for my supervisor in Microsoft Access. What it requires is for dates in certain fields to be in sequential order. What I want to do this is to check if the date in the field I'm entering is "later" than the previous field.
I only found one function that possibly could help me, but I'm having trouble using it.
DateDiff ("d", "FirstDate", "LaterDate")
If FirstDate is earlier than LaterDate, then the resulting expression is greater than zero. Otherwise the result is negative. A possibility is to "trap" the negative result, but I am unsure of how to do it.
Help!!! Thanks.
------------------ I can resist anything....... Except Temptation