Date Filter in Report

[Will]

I have a database of records that span over 3 years.
I want to cull out the records from a specific year in a
report. I have a date field in my table, how do I get
the report to only report the records from the year I
want say for example 2002?

thanks for the help

 

[Fredg]

Will,
Base the Report on a query.
In the query, on the Datefield's criteria line write:

Year([DateField]) = [enter year wanted]

When the report is run, you will be prompted for the year.
Enter 2002.

 

[Ken Snell]

You could use a filter criterion such as this when you open the report:

"Year([DateField])=" & DateVariable

where DateVariable is a variable with the "year" value that you want to use.