Can I determine on what day I added data to a table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to make an accounting for my company and need to know on what dates I
entered data into certain tables? Is it possible to go back and find this
information in the database?
 
Nope. You can add timestamps and begin tracking this from this point
forward, but if you were not tracking it in the past, you are out of luck.
 
he doesnt mean TIMESTAMPS

he means a Date/Time field; and you can either default this to NOW() or
GETDATE() depending on if you're doing this in MDB (via VBs' NOW()
function) or SQL Servers now function = Getdate()

TimeStamps won't really tell you date information; right?

-aaron
 
You must log in or register to reply here.

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

Updating tables when you input new data 0
How to Populate Data from a table to another 0
VBA - retrieve data on last create named range from previous inserted named range 0
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Access Determine what query to run based on a checkbox 0
Modifying Tables (Adding Field) 1
Adding records to a table 18
Entering data from a table into a form. 1

Back
Top