How do I search for a specific year in a query?

[Guest]

I am using a Membership database in Access 2003.

I have a Date field created and want to find all records in that date field
with a specific year. The query feeds a report. I want to print reports
showing all members in 2007, all in 2006 etc. So I may send out re-newal
notices to past members.

 

[fredg]

I am using a Membership database in Access 2003.

I have a Date field created and want to find all records in that date field
with a specific year. The query feeds a report. I want to print reports
showing all members in 2007, all in 2006 etc. So I may send out re-newal
notices to past members.

Add a new column to the query.
TheYear:Year([DateField])
As criteria on this column, write:
[Enter Year]

When prompted enter 2006

 

[Guest]

Add a new field to your query grid like this ---
RptYear: Format([YourDateField], "yyyy")

Use this as criteria ---
[Enter 4-digit year]