Dates limited to post 1900

The UK's most regular instructor-led training courses.
Training information: training database microsoft access · Microsoft.access.courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · High Priority · Version 2003

1 post

ReplyMon 1 Feb 2010, 15:49Delegate Victoria said...

Victoria has attended:
Access Introduction course

Dates limited to post 1900

I am intending on using Access to create a simple archive database and have records dating back to the 1890s. How will I enter this information onto a table when Access will only allow dates after 1900?

Thanks

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	5		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£156	£161
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

1,056 posts

ReplyWed 3 Feb 2010, 10:15Trainer Andrew said...

RE: Dates limited to post 1900

Hi Victoria

Thank you for your question.

In principle Access should be happy sorting dates earlier than 1900 in a table that contains a date field. I tried a quick test and it seems to work but it may I haven't fully understood how your database will be set up.

To test I created a table and in design view I created a date field. Then in Datasheet view I was able to enter records with dates earlier than 1900 then sort records in date and reverse order.

Problems can arise if date information is imported from Excel 2003. Excel will convert dates earlier than 1900 into text values rather than date values. They appear correct but when imported to Access for example they may generate errors. Could this be the situation you are encountering?

Tell me more about what you are hoping to achieve with your database and the problems you are encountering and I will try and help further.

Kind regards,
Andrew

· Microsoft Access, an Efficient Database Tool
· What's In A Name? Creating A Company Personnel List Using Microsoft Access
· Why consider Access Visual Basic training?
· Convert a Paper Trail to a DBMS
· Access Corruption Avoidance Tip #3: Stay Connected

Please browse our web site to find out more about
training database microsoft access and other Microsoft training courses.