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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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

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

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