Labelling a new record in subform

[tigger]

Hi there - hope someone can help.

I am trying to create a report that shows a series of actions and identifies
the latest log entry for each action so obviously need some method of
programmatically labelling a new log entry record when it has been created.

Each log entry relates to an action, which in turn relates to a
non-conformance, which in turn relates to an audit so I have tried using DMax
with the Audit ID, NCR ID and finally Action ID as criteria to identify the
latest LogID in my table. This works great, but I can't figure out how to
label the latest action and remove labels from previous actions. Do I need to
do this on a form or can it be done in a query?

Can anyone help?

Thanks