Running log of dates

[snowboarder234]

I would like to have the update field display ALL dates in which data has been added/deleted from each record. What is the best way to go about doing this?

[June7]

You want this for a report? Does this help http://allenbrowne.com/func-concat.html

[Missinglinq]

Where are you storing these dates, in a separate Table? For a given Record, this type of Field would normally be populated with the date each time a change was made, on that Record, rather than separately storing each date elsewhere.

And depending on how many of these dates there are likely to be, a Listbox might be a better way to display them, or even a small Subform. With a Subform, you could simply link the the Form/Subform using whatever unique identifier you're currently using.

Linq ;0)>

[snowboarder234]

Reply to SuperModerator's post: Not for a report, I'm entering it into a form.

[snowboarder234]

Where are you storing these dates, in a separate Table? For a given Record, this type of Field would normally be populated with the date each time a change was made, on that Record, rather than separately storing each date elsewhere.

And depending on how many of these dates there are likely to be, a Listbox might be a better way to display them, or even a small Subform. With a Subform, you could simply link the the Form/Subform using whatever unique identifier you're currently using.

Linq ;0)>

It's being stored in a table, and I enter the data through a form. The problem is each date for each record is overwritten with the most current date change. I want a record of all dates for each record.

[June7]

Memo fields can maintain a history of changes. Review http://office.microsoft.com/en-us/ac...080750367.aspx

For other fields you will have to save records. Review
http://access.mvps.org/access/modules/mdl0021.htm
https://www.accessforums.net/forms/h...tes-20419.html