Extracting by year

[NWTrust]

This is an Access 2003 problem. I have a table - Table1 - with a field 'Date' containing dates in medium date format. I want to be able to create a second table from Table1 containing only those records matching a year only entered in a separate form. Is this possible? I would appreciate any help you can give me.
NWTrust

 

[Golom]

Select * INTO SomeNewTable
From Table1
Where Year([Date]) = [Forms]![FormName]![TxtYear]

 

[NWTrust]

Thanks, Golom. Problem solved!
NWTrust