[AccessD] Birthday in table

Call me lazy, Lembit, but I take the position that your birthday is the same
every year, so I would default the year part to this year, and edit it to
suit increased knowledge.

A.


On 6/15/07, Lembit Soobik <lembit.dbamail at t-online.de> wrote:
>
> Hi, everybody,
> I have tried to define a field in an A2003 table - in fact 2 fields - for
> birthday.
> thing is, in many cases I know only day and month, not the year.
> so I tried two fields: DD.MM as first and YYYY as second field.
>
> a) it wont let me enter a year, and I had to make it Integer instead.
>
> b) I can enter a day and month but it will add the year 2007 (behind the
> scenes) and therefore wont allow me to enter 29.02
>
> now I can of course split it up into 3 fields: DD, MM, YYYY, but this
> would
> allow any error resultin in 41.21 as DD.MM
>
> so, how do you handle that? or do you allways have the full date including
> year?
>
> thanks for any help
>
> Lembit
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>