Lookup date

[pwicr]

I have a date field that is just a typical date field.

When I do a query, I want to look up by just the YEAR in that date field. Can I do that or do i need a separate text field with JUST the year entered in?

or can i have a field in my table that just looks up the main date field and displays/uses ONLY the year??

 

[billmeye]

Your in luck, just use the Year function:

JustYear:Year([YourDate])

Then in the criteria for that field either type in the year you want or pull it from a form or use a prompt like [Please Enter the Year]

 

[pwicr]

Thanks! Works perfectly!!

 

[jdraw]

For reference:

A good source of info on Access functions is
http://www.techonthenet.com/access/functions/index.php