I have a report that has a column for a Training Code, I then have three date columns: Start Date, Req Date, and Exp Date. I have the report set so it will select distinct records only, however, the employee may have taken the training years ago and the code and date show up. I am getting duplicate training codes because they are in date order, I would like to have the Training Code to show up once with the most recent date.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.