Date search by year only

[superrob5]

I want to run a query that looks at a date and ruturns all info for a given year. Is there away to do this
Instead of searching for example 01/01/2003-12/31/2003
criteria is Between [From Date] And [To Date]

I wouldl like to be able to search by typeing in 2003.

 

[dcx693]

Use the Year() function. In the field line, have a function that works like this:
Year:Year([dateField]). (That first Year before the semicolon tells Access what you want to call the field). You can then place 2003 or whatever year you want into the criteria line.

 

[superrob5]

thank you