I have a database that has several date fields, Order Date, Req Date, and Canx Date. If the Canx Date is left blank, it automatically fills in 1/1/1900. I want to create criteria in a query that says if (canx date="1/1/1900",req date, canx date).
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Criteria
- Thread starter gbrigman
- Start date
- Status
Similar threads
- Question
- Locked
- Question
