Create a query to find last used 1

[nissan240zx]

Hello All,
i have a table with these 4 fields. Its a table that stores information on employee attendance. Managers enter the informaiton about their subordinates and saves it. We think that some of the managers are not using it as required. So need to run a query to check when did the managers made their last entry.

Table name Attendance

Fields:
Date - vacation date
Reason - type of vacation (sick, vacation, holiday etc)
Employee - Employee name
Team Leader - Manager name

Based on this how do I find the results.
I just want to find out managername, last entry date.
Thanks in advance.

A good programmer is someone who looks both ways before crossing a one-way street. - Doug Linder

 

[lupins46]

Unless you record the datetime of each entry then you can't do this. Access doesn't keep any details.

 

[nissan240zx]

You are right..we need a timestamp to find this..
Good advice..thanks..

A good programmer is someone who looks both ways before crossing a one-way street. - Doug Linder