Date problem

[sougata]

Hi,
I have 1 table where I want to store birthdays of employees.

like
Name -Micheal John
Birthday - 20 April


But in access I found they also want the year (eg> 20 Apr 1980)

But I don't want the year, only MONTH and DAY

Is it possible?

 

[RuralGuy]

What is wrong with storing the year as well? You can always get back the Month and Day.

 

[Moniker]

Just use the format function. This will return "12/31":

Format(#12/31/06#,"mm/dd")

Replace 12/31/06 (keep the pound signs), and set that to the value of your field.

~Moniker