[AccessD] Birthday in table

You could try this: 

Make birthdate field a date, as if you planned to always know the
person's actual date of birth.

>From your interface, offer the ability to enter any part of the
birthdate.  Many of our clients are really after 'approximate age' , so
we gave the opportunity to enter '37' in a text box labeled 'Current
Age', and then converted that to a birthdate of today's date in the
appropriate year.

In your case, it would be a little more complex, but if you had separate
text boxes for month and day as well as for year, with an approximate
age option so you could calculate an approximate year, you could put it
all together into a valid date before writing out to your table. 




HTH,


Liz 


Liz Doering
elizabeth.j.doering at wellsfargo.com
612.667.2447


This message may contain confidential and/or privileged information. If
you are not the addressee or authorized to receive this for the
addressee, you must not use, copy, disclose, or take any action based on
this message or any information herein. If you have received this
message in error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lembit Soobik
Sent: Friday, June 15, 2007 9:04 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Birthday in table

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