Date Filter in Report

  • Thread starter Thread starter Will
  • Start date Start date
W

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
 
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.
 
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.
 
Back
Top