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.