In some Microsoft Office Access tables, it is important to keep track of the date or the date and time when a new record is added. This is often referred to as a date or time stamp. You can use the Now or Date functions to have Access automatically fill in the date or time when a new record is added. Use the Now function to fill in the date and time, or the Date function to fill in just the date.
Add a date or time stamp field
- In the Navigation Pane, double-click the table to which you want to add the time stamp field.
Access opens the table in Datasheet view.
- In the first blank column, double-click the column header labeled Add New Field, type a name for the field, such as Date Added, and then press ENTER.
- Select the column that you just added and then, under Table Tools, on the Datasheet tab, in the Data Type & Formatting group, select Date/Time in the Data Type list.
- Click the Microsoft Office Button and then click Save, or press CTRL+S.
- On the Home tab, in the Views group, click View, and then click Design View.
- In the Field Name column, click your new field.
- Under Field Properties, on the General tab, click in the Default Value property box, and then type Now() or Date().
- Click the Show Date Picker property box, and then select Never from the list.
- Save your changes, and then close the table.
Each time you add a new record to the table, Access automatically inserts the date or the date and time in the Date Added field.
Top of Page