I am sure I am missing something obvious here....
I have a field which tracks the location of a product [SlideData].[slocation] which changes regularly throughout the day and I would like a record of every time the field changes with timestamp.
I've made a new table [Tracking] with fields that correlate with the [slidedata] table so that I can make an append query~ but i am having issues with the criteria to limit what is being appended to that table.
My hope was that when the field [slocation] is updated in the form, that the append query would run and only add the the items where Slocation has changed~ instead (presumably because I didnt have any criteria) it added the entirety of the [slidedata] table to the [tracking] table.
Any help would appreciated.
-Matt