Date change on a FIELD

K

kateri4482

Is there any way to know the date when a field changes? Like the date
modified when a form changes? Same thing, only on a field. I need this date
to be displayed in a table so that I can run queries and reports from it.
 
J

John W. Vinson/MVP

Is there any way to know the date when a field changes? Like the date
modified when a form changes? Same thing, only on a field. I need this date
to be displayed in a table so that I can run queries and reports from it.
Click to expand...

Only if you record that information yourself, either in a date/time
field in the same table or in a separate change-log table. Access does
not record it for you.
 
Top