Date

[Schoch]

Hi,
I'm trying to work on a huge Database project that involves lots of
dates. I have records that go back to 1897. Anyways I'm entering data in for
each day of the year and I was wondering if there is a faster way like in
Excel that will automatically pick up the date. Example 02/01/1897,
02/02/1897, 02/03/1897...and so on. This there any formula and anything that
will help make it go faster???

Thank You,

Amanda

 

[Jeff Boyce]

Any chance you could do the dates in Excel and import them into Access
afterwards?

(no, since Access is not a spreadsheet, the feature you'd use in Excel is
not available in Access.)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Dirk Goldgar]

Hi,
I'm trying to work on a huge Database project that involves lots of
dates. I have records that go back to 1897. Anyways I'm entering data in
for
each day of the year and I was wondering if there is a faster way like in
Excel that will automatically pick up the date. Example 02/01/1897,
02/02/1897, 02/03/1897...and so on. This there any formula and anything
that
will help make it go faster???

Thank You,

Amanda

Where are these dates going, Amanda? You can write a code snippet or a
table-query combination that will generate dates in an arbitrary range, or
you can use code on a form to automatically generate the next date for each
new record you create. That latter may be what you're after, but it's hard
to say without more info.