Year(Now()), before Year(Now(), or null

J

jadabug28

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

Jadabug

Jerry said:
<Year(Date())+1 Or Is Null
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


[email protected] said:
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...

Thanks, worked like a charm.
Click to expand...
Click to expand...
 
Top