simple filter question

[iainrkemp14]

i have a table with a columm that includes dates (4/15/2003)

how can i set a filter that will show only those records from 2003? right now it will only filter with the specific dates rather than showing all from the same year.

cheers,

- iain

 

[ToeShot]

In a query in the criteria row under the date column put this

Year(Now())





Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait