[ms_access] Convert mm/dd/yyyy to only show yyyy

[Mark Hallgath]

I need to write a query in Access 'Design' view that takes the 
birthdate field in my table and build a separate column to only show 
the year.  (ie, 2/27/1986 to display as 1986 or 10/12/1987 as 1987). 
This is easy enough to do in Excel, but I am trying two include it in 
an Access query so that I don't have to convert it manually in Excel 
every time.  Any help will be very much appreciated.