I wonder if you can help me.

I am new to Access database and I am struggling to do what I want.

I am setting up my table and one of the fields I want the default value to
be the current year. I set the field type I tried using the date$()
function but that gives me the whole date i.e. day month & year in the
format dd/mm/yyyy. I set the data type for the field as date\Time.
All I want is the year in my field (i.e. 2005).

How do I make the current year the default value in a field and what do I
set the data type to? Please do not be too technical as I am only just
starting using Access.

I hope you are able to help.

I appreciate any help or information given.

Thanks!

You can use year(date()).

On Tue, 4 Jan 2005 14:57:58 -0000, Neil Hindry wrote:

What you do depends upon what you intend to do with the data.
To actually store the year value in a table, as a number, i.e. 2005,
you would set the field's datatype to Number, Field Size to Integer,
and set the default property to
= Year(Date())

To actually store the year is probably not necessary and not a good
idea.
Simply store the date.
You can use the stored date value to do anything that you would have
done just storing the Year as a number.

For example, to display the year, using the date as the value, simply
set the Format property of the control to:
yyyy

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.