--- In [email protected], "Mark Hallgath" <[EMAIL PROTECTED]> wrote:
>
> 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.
>
create an update query to update a text field in your table and in the
Update to: row of the query builder use the build in function DatePart
("yyyy",[date]) where yyyy is a text field (column) in your table and
date is the name of the field that contains the date from which you
wish to extract the year.
