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.
It would look like:
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.