 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / June 2006Year(Now()), before Year(Now(), or null
I have a field in a query called NextReview, and currently another field NextReviewYear: Year([Next Review]) with the criteria Year(Now()). I need this criteria to find all dates for the current year, before the current year, or null. How is this possible? I'm sure it is relatively simple, but I'm a newb! Thanks... <Year(Date())+1 Or Is Null  SignatureJerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > I have a field in a query called NextReview, and currently another > field > NextReviewYear: Year([Next Review]) with the criteria Year(Now()). I > need this criteria to find all dates for the current year, before the > current year, or null. How is this possible? I'm sure it is > relatively simple, but I'm a newb! Thanks... > <Year(Date())+1 Or Is Null > -- [quoted text clipped - 9 lines] > > > >Thanks, worked like a charm. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.