Good Morning!
I am trying to create a report of all employees and their last login process code.
I have three tables to work with:
1. Employee (PK EmployeeCode)
2. Production (PK Code-index key, assigned every time a new line is added to the table- not the employee code, although that field is part of the table structure)-lists all employees and all processes they clocked into for every day
3. ShopLogIn (PK EmployeeCode) - lists last time the employee clocked in with any process.
My report needs to show:
EmployeeName, EmployeeCode -Employee table
LastLoginTime-ShopLogIn table or Production table
LastProcess -Production Table

How can I get that? I grouped the records in the production table by employee code and in my details section I see all records for each employee, in descending order by the date stamp on each process they clocked into. How can I suppress everything except for the last process for each group?    

Thank you!
Julia.

Edited by rusmanicai - 01 Jul 2013 at 9:19am

Wow. I tried so many things, including this, but I have two groups, and I put the data in the first group (department) and not the second group (employee). Thank you!