best training access course - recording date and time

Hi Sabine

Thank you for your question.

As you can only store one value per field, what you could consider doing is creating a separate table to store comments and the date and time they were entered.

This table could then be linked to records in your existing table by creating a relationship between the existing table and the Comments table.

To view the comment history, you would need to create a subdatasheet in a table or a subform in a form or a query.

To show the last comment, use the LAST function.

I hope this helps.
Amanda