Access table updating time stamp

Rated 4.19/5 based on 665 customer reviews

In addition to using date functions for controlling and streamlining data entry, Microsoft Access date functions really shine when used as query criteria to filter or limit query results by date or date range.

In the previous example, we created a field to track when employee records were last updated.

If you have never used Microsoft Access date functions, take a look at this quick Beginner's Guide to Microsoft Access Built-in Date Functions that I recently created and shared on our Office You Tube channel.

If you find yourself constantly entering whatever today's date is in your Access forms or tables, you are wasting valuable time.

Date functions are also useful for controlling what dates are allowed to be entered into a given Date/Time field.

Let's say we had a sales table where we only want users to enter a transaction occurring on or before today's date.

For Date2, however, since we want to save and reuse the query, we want to reference the Now() function, to calculate using the system date and time.Once this property is set for your field, users can skip past this field when doing data entry or modify the date as necessary.Alternatively, if the field is time-sensitive as well, you can also use the Now() function in place of the Date() function to store both the date and time information.We can achieve this level of control by writing an expression in the field's Validation Rule property box inside the table.For more examples of validation rules and expressions, please visit the Microsoft Help Topic Create a validation rule to validate data in a field.

Leave a Reply