Re: Year(Now()), before Year(Now(), or null
- From: "Jadabug" <jadabug28@xxxxxxx>
- Date: 30 Jun 2006 09:58:29 -0700
Jerry Whittle wrote:
<Year(Date())+1 Or Is Null
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"jadabug28@xxxxxxx" wrote:
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.
.
- References:
- Year(Now()), before Year(Now(), or null
- From: jadabug28
- Year(Now()), before Year(Now(), or null
- Prev by Date: Re: Problems with SQL Query Counting Unique Records
- Next by Date: Querying a month range...
- Previous by thread: Year(Now()), before Year(Now(), or null
- Next by thread: Re: Selecting 60 days ago from text date field
- Index(es):
Relevant Pages
|
|
