JUst the year lookup

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

Guest

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

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

Enter 2005 when prompted.
 
Thanks!! Works Great!


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

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

Enter 2005 when prompted.
Click to expand...
 
Back
Top