Use 12/30/1899 in access 2007

[obelix1]

I have a "DoB" field, that is used to calculate age for a group of patients.
One of the patients has a "DoB" od "12/30/1899". When entering this patient,
the whole record gets corrupted showing Chinese characters or ASCI characters
in some fields, as soon as a started update query is calculationg the age and
trying to store it in another field of the same record. I really appreciate
any help, how I can avoid this?

 

[Maurice]

I do hope you have a backup of your db. Chinese characters showing up usually
means that the db is corrupt. Do'n't try fixing this in this db but instead
use the backup...

 

[Paul Shapiro]

Is 12/30/1899 the real birthdate, or is this the displayed data because
Access defaults to initializing the date with a zero value? If it's the
latter, you could try deleting the data value, so the field is null. Change
the field's Default property from 0 to blank.

You would also do better to eliminate the Age field. Instead of updating the
redundant data, use a query to calculate the age when you want to use it.
The only time it makes sense to store redundant data is if the calculation
is so lengthy the delays are unacceptable. This would not be the case for
age.