Update Query

  • Thread starter Thread starter Michael Cooper
  • Start date Start date
M

Michael Cooper

I have a table with the following columns

Name (Text)
Address1 (Text)
Address2 (Text)
Address3 (Text)
Address4 (Text)
Post Code (Text)

The table contains approx 16,000 records. I would like to
have another column which when i alter any of the above
columns will tell me when the above columns last had a
change.

Thanks

Michael Cooper
 
You will need to add a column to store the information AND you will need to
control the input of all data via forms (not directly into tables via SQL
queries, direct data entry, or cut and paste).

Use the form's before update event to populate the new field with the current
datetime. The Now() function (if you need date and time) or the Date() function
if you need only the date.

Post back if you need help with the code.
 
Back
Top