Due dates

[Mehbastan]

Hi everyone.
I really need your help. I am fairly new with MS Access and have made a database that holds my Customers info. One of the field in my database is ContractDueDate which holds the YEAR that customer's Contract are due for renewal. i.e 2009 (Days & Months are not important)
I would like to get a report of those contract that are either due or going to be soon up for renewal a year ahead of time.
What should I write in the Criteria field of the query?
I would really appreciate your answer.
Thanks

[dcrake]

<=Year(Date()+1)

This is adding one year to todays year element then asking to show all those that are equal to or less than this value. In other words <=2010.

You will have to include another clause that only brings up the ones that are outstanding.

David

[Mehbastan]

I have 2 contracts one was due 07/2009 and the other is due on 08/2010
The query must bring up both since one is past renewal by a month and should have been renewed the other is due in a year.
The <=Year(Date()+1 does not bring up either one why?

[dcrake]

You originally said months and days were not important however you stated month and year in your last thread?

What are you actually storing in the table?

[Mehbastan]

I'd like to have the field as YYYY only but I can not make the field accept Year only, how is that possible without putting a fake month in there?

[Mehbastan]

I Found the answer Thanks. I made the ContractDuedate into a Numeric Field and added
<=Year(Date()) to the criteria which brings up the right customer every time.
Thanks for your help