Roberta

If you want to select all the dates within a single year, you might try using where year(date) = 2001

The function call may not be 100% accurate since I was replying off the top of my head but I believe a quick glance in the help should confirm the syntax. I was recently looking at some Access code I did in the 90s that used the year function and it seemed to work ok.

Best Regards
Anthony Case