Skip to Content
0
Former Member
Feb 27, 2009 at 10:49 PM

Using Next function within a Group

22 Views

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)?