JUst the year lookup

[KAnoe]

I would like to have the user lookup just the year in a date field in a
Query. Like Enter Year] . I would like it so the user could just type in 2005
and on the date that are in 2005. Any help would be great.

Thanks

 

[fredg]

I would like to have the user lookup just the year in a date field in a
Query. Like Enter Year] . I would like it so the user could just type in 2005
and on the date that are in 2005. Any help would be great.

Thanks

Add a new column to the query grid:
Year([DateField])
as criteria write:
[What Year]

Enter 2005 when prompted.

 

[KAnoe]

Thanks!! Works Great!

I would like to have the user lookup just the year in a date field in a
Query. Like Enter Year] . I would like it so the user could just type in 2005
and on the date that are in 2005. Any help would be great.

Thanks

Add a new column to the query grid:
Year([DateField])
as criteria write:
[What Year]

Enter 2005 when prompted.