sandra1
Last Activity: Sep 29 '14, 08:12 PM
Joined: May 8 '14
Location:
-
sandra1 replied to Pull up only recent dates from employees who have multiple records with multiple datein AccessThere must be something im doing wrong, because it wont let me run it, it keeps sayin syntax error in JOIN operation. -
sandra1 replied to Pull up only recent dates from employees who have multiple records with multiple datein AccessCode:SELECT Employee.FirstName, Employee.LastName, EmployeeInfo.WorkCellNumber, EmployeeInfo.WorkCellType, Employee.IsActive, EmployeeInfo.ChangeFormDate FROM Employee INNER JOIN EmployeeInfo ON Employee.EmployeeID = EmployeeInfo.EmployeeID;
Last edited by Rabbit; May 8 '14, 10:20 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.Leave a comment:
-
sandra1 replied to Pull up only recent dates from employees who have multiple records with multiple datein Accessi have a query with fields of, first name, last name, work cell number, work cell type, is active and change form date. So when i run it all the dates from the change form date field come up, bt i only want to see the most recent date of each employee.Leave a comment:
-
sandra1 replied to Pull up only recent dates from employees who have multiple records with multiple datein Accessi want to view it in a queryLeave a comment:
-
sandra1 started a topic Pull up only recent dates from employees who have multiple records with multiple datein AccessPull up only recent dates from employees who have multiple records with multiple date
i have an employee database,my employees have multiple change forms with diff dates, but i only want to find the most recent date from each employee. How do i do that?
No activity results to display
Leave a comment: