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

  • Thread starter Thread starter jadabug28
  • Start date Start date
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...
 
Jerry said:
<Year(Date())+1 Or Is Null
--
Jerry 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...

Thanks, worked like a charm.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top