Need help with creating a cross tab report that would identify the last date an employee entered time.
I have two main tables where an employee (Employees) saves the date and hours spent on a task in a table called TimeSheetData.
The query I want is basically give me the last date each employee has saved time which would pull from the fieldname: DateEntered.
I provided a Microsoft Access sample - note how some employees maybe blank cause the DateEntered did not get out.
How would I get this accomplished? I want it to list all employees whether time was entered or not. ee-question-last-date-emp-entered-.accdb