Dates before 1900

[Spamnchips]

Hi,
It is a long time since I seriously used Access and I am a bit rusty. I am trying to create a databse to genealogical information and need a date format that will handle anything from 2007 way back to the 1600's. I seem to remember that MS software uses a numerical system for assigning dates but works from 1900 onwards. I am sure there must be a "fix" for assigning pre 1900 dates but cannot find a reference.

Is there anyone out there who has experience of this kind of problem who would be kind enough to offer some advice please ?

Regards

John

 

[neileg]

Access handles earlier dates as negative numbers. I don't think there's a problem to solve!

 

[Dennisk]

Access handles dates
from January 1, 100 to December 31, 9999

 

[Spamnchips]

Thanks to both of you. I will go ahead and play.

Regards

John

 

[Niniel]

You could always just enter the date as text in a text field, could you not?

 

[Mile-O]

You could always just enter the date as text in a text field, could you not?

You can't sort by date if it's text.