T
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
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