adding new data records and dates

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

Guest

I have a table of patients that I must update with some new info. I will
import a excel document to acomplish this. Q: is there a way to add a field
to the table to let me know when I imported the info. After 4-5 imports it
might get confusing.

Thanks (~:~)
 
Add a DateTime fied to your table and set the default to =Date() or =Now()
based on whether you need a time component with the date.
 
I created a field Date Entered, and set the default value to =Now(), however
there isn't any date dispalyed. Any thoughts
 
It should indicate the date/time when a new record is added. You will have
to enter data in any existing records.
 

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

Back
Top