|
| 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
September 30th, 2004, 09:37 PM
|
|||
|
|||
how do I compare a number to the current year?
I Microsoft Access I have a field that contains a 4 digit number that I want
to be able to compare it to the current year. How do I do this? I am using Microsoft Access 2002. 
|
|
#2
September 30th, 2004, 10:35 PM
|
|||
|
|||
|
Hi,
You can't do that directly from a table so I assume you mean you have a form that displays the number? You don't say what you want to happen or what kind of comparison you want, so the only thing I can offer is to use the DatePart function to get the current year: DatePart("yyyy",Date()) HTH Dan Artuso, MVP "Novice" wrote in message ... I Microsoft Access I have a field that contains a 4 digit number that I want to be able to compare it to the current year. How do I do this? I am using Microsoft Access 2002.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Detect current slide number, and notes page | Snoop | Powerpoint | 1 | September 16th, 2004 05:57 PM |
| Add a FIXED MONTH and DAY with the CURRENT YEAR | texcel | General Discussion | 1 | June 23rd, 2004 01:36 AM |
| day number in a year | Peter B | Worksheet Functions | 7 | January 9th, 2004 09:54 PM |
| Rounding Functions | Teacher | Worksheet Functions | 2 | January 7th, 2004 02:27 PM |
| date conversion | web_time | Worksheet Functions | 10 | December 25th, 2003 06:51 PM |
Linear Mode
