I've grouped my records by Employee Name and I want to show training they have received.
Each employee has either 0, 1 or 2 trainings. I am using the Training Field and then using it again with the Next Function to capture the 2nd training an Employee recieved. This is so I can get everything on one line.
However, if an employee has 0 or 1 training records, the Next field displays the first training record of the next employee. I would want it to display nothing if there wasn't a 2nd training record for that employee.
Is it possible to limit the Next function to only the Next record in that group (Employee)?