|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 30th, 2006, 03:41 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Year(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... 
|
|
#2
June 30th, 2006, 04:33 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Year(Now()), before Year(Now(), or null
Year(Date())+1 Or Is Null
-- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. " 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...
|
|
#3
June 30th, 2006, 05:58 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Year(Now()), before Year(Now(), or null
Jerry Whittle wrote: Year(Date())+1 Or Is Null -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. " 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Nulls in a query | Hal2604 via AccessMonster.com | Running & Setting Up Queries | 4 | June 23rd, 2006 07:51 PM |
| Build new row, consolidating columns... | nycdon | Running & Setting Up Queries | 2 | March 15th, 2006 10:13 PM |
| Convert Count(Case()) SQL Server Query to Access | [email protected] | Running & Setting Up Queries | 3 | November 17th, 2005 11:06 PM |
| Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
| Access inconsistencies | Hoopie | Running & Setting Up Queries | 2 | June 15th, 2004 10:53 AM |
Linear Mode
