AnsweredAssumed Answered

Sub Summary Report with Most Recent Date

Question asked by annemm63 on May 28, 2018
Latest reply on May 30, 2018 by annemm63


I am trying to create a sub-summary report that is sorted by account codes and that list each employee's name who is paid out of that code and their percentage. The problem I am having is creating a Find that pulls only the most recent codes for each employee.  Employee codes are listed on a PAF form layout in a portal and each PAF has an effective date. Employees have multiple PAFs and multiple codes.  The tables are Employee, PAF, PAF Account Codes, Account Codes.


Any help would be greatly appreciated.