=format([your_field],"YYYY")
--- On Fri, 10/31/08, Mark Hallgath <[EMAIL PROTECTED]> wrote: From: Mark Hallgath <[EMAIL PROTECTED]> Subject: [ms_access] Convert mm/dd/yyyy to only show yyyy To: [email protected] Date: Friday, October 31, 2008, 11:59 AM 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. [Non-text portions of this message have been removed]
