Finding a year in a date field

[Bob]

I need to pull all records for 2008 in a date field called completed. I know
this shoudl be easy but I can never seem to find any help on date fields that
seems to relate. I just want to create a simple query.

 

[Ken Snell [MVP]]

SELECT *
FROM TableName
WHERE Year(DateFieldName) = 2008;

 

[Bob]

As allways Ken I appreciate the quick response and accurate suggestion.
Works great.