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.
- Open the Microsoft Access database containing the table to which you wish to add a date or time stamp.
- In the left window pane, double-click on the table where you would like to add a date or time stamp.
- 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.
- 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.
- 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.
- In the Field Properties window pane at the bottom of the screen, type “Now()” (without the quotes) into the Default Value box.
- 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.
- Save your database by pressing the Microsoft Office button and selecting the Save menu item.
- Verify that the new field works properly by creating a new record. Access should automatically add a timestamp to the Record Added Date field.
- 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)