Sunday, March 15, 2020

Adding a Date or Time Stamp to an Access 2010 Table

Adding a Date or Time Stamp to an Access 2010 Table 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 fact, it shouldnt take more than 5 minutes. In this tutorial, I explain the process step-by-step.  Note: These instructions are for Microsoft Access 2010. If you are using an earlier version of Access, please see Adding a Date or Time to an Access Database. Adding a Date or Time Stamp 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 disk icon in the upper left corner of the Access win dow.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: 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.