1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Discuss in my forum

How To Add a Date or Time Stamp to an Access Database Table

By

How To Add a Date or Time Stamp to an Access Database Table
Mike Chapple
There are many applications where you may wish to add a date/time stamp to each record, identifying the time that the record was added to the database. It’s easy to do this in Microsoft Access using the Now() function. In this tutorial, I explain the process step-by-step.

Note: These instructions are for Access 2007. If you are using a later version of Access, please read Adding Timestamps to an Access 2010 Database.
Difficulty: Easy
Time Required: 5 minutes

Here's How:

  1. Open the Microsoft Access database containing the table to which you wish to add a date or time stamp.
  2. In the left window pane, double-click on the table where you would like to add a date or time stamp.
  3. Switch the table into design view by selecting Design View from the View drop-down menu in the upper left corner of the Office Ribbon.
  4. Click on the cell in the Field Name column of the first blank row of your table. Type a name for the column (such as “Record Added Date”) in that cell.
  5. Click the arrow next to the word Text in the Data Type column of the same row and choose Date/Time from the drop-down menu.
  6. In the Field Properties window pane at the bottom of the screen, type “Now()” (without the quotes) into the Default Value box.
  7. Also in the Field Properties pane, click the arrow in the cell corresponding to the Show Date Picker property and select Never from the drop-down menu.
  8. Save your database by pressing the Microsoft Office button and selecting the Save menu item.
  9. Verify that the new field works properly by creating a new record. Access should automatically add a timestamp to the Record Added Date field.

Tips:

  1. The Now() function adds the current date and time to the field. Alternatively, you may use the Date() function to add the date without the time.

What You Need

  • Microsoft Access 2007 (Earlier versions use similar, but not identical steps)
  1. About.com
  2. Technology
  3. Databases
  4. Microsoft Access
  5. Tutorials
  6. Adding a Date or Time Stamp to an Access Database Table

©2014 About.com. All rights reserved.