Keeping track of field updates

  • Thread starter Thread starter Julian
  • Start date Start date
J

Julian

I would be greatful if anyone could advise me on how I
could keep track of dates when a field is updated in
access. eg. If I were to monitor the growth of poppies in
my garden there might be 1 poppy to start off with in
spring and then 2 a month later. How could I track the
dates each time I update the growth field in order to
monitor rate of poppy growth?
 
Allan Browne's Audit Log example is great. If you're just looking for a way
to monitor the change in size over a time period, you might want to consider
creating a second table with three fields:

table 2
poppy_ID (number)
size (number)
datetime (datetime: set default =now())

Then create an autonumber field in your first table if you don't already
have one, and relate it to the second table. Then you can record many
sizes/times for each poppy.

Robert Smith
Kaizen Software Solutions
http://www.kzsoftware.com/services/msaccess/
 
Back
Top