Date

S

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
 
J

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
 
D

Dirk Goldgar

Schoch said:
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
Click to expand...


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.
 
Top