How do I find the date a record was created in Access?

G

Guest

I just recently took over an Access database that stored Business License
information in our county. Besides the database, we have paper files with
the original BL application stored in a filing cabinet.

I have been assigned the task of entering a Start Date for the business in
the database. This means going through the paper files and manually entering
the Start Date for all businesses. The problem I'm having with this is some
paper files have gone missing. For those missing files, I have no means to
find the start date.

What I was wondering is if there's a way I can find the date a record was
created? This way, I can enter this date as the business's start date.

Any help will be appreciated.
 
G

Guest

You would only have that date available if it is being stored in one of the
tables. If the db doesn't store the entry date, then you are out of luck.

Sharkbyte
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to store the date a record was created, automatically. 3
Check if a date exists in a record 1
Extracting only the Date part of a Date/Time field 5
Entering (& locking down) the date that a record was created 1
Access 2000 - reporting/query within specified dates?? 3
Newbie question about Access and report 3
Duplicating date in a field to a new record 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0

Top