Recent content by essexguy2015

Thanks I had been looking at this but not sure where I am going wrong the results show as Start End Ref Employee Previous Ref 06:29 07:14 VP1 Patricica 07:15 08:15 SL1 Patricia VP1 08:16 08:46 PS1 Patricia VP1 and so on showing VP1 for the remaining tasks rather...

Hi all I currently have a table where we are logging a task number against a date and time for each employees to track activity What I am looking to do is in a query have access lookup the previous reference number for the employee before the date/time of the individual record but on the same...