Calculating Last Day Worked

[djclntn]

I have a query with these fields:

• EmplDate – DateTime
• EmplyID --- Test
• Hrs – Numbers

I have a Form with the above field, but I want to add another field. I want to see how many days each/an Employee last worked from the current date they’re working.

I.E.


JoLMrtn 11/23/2013
KrnEClntn 11/20/2013
JoLMrtn 12/1/2013 7 (Last worked 7 days ago)
KrnEClntn 12/5/1013 15 (Last worked 15 days ago)

*I’m unable to come up with the right criteria. Any suggestions would be much appreciated!

[AlexHedley]

You could look into the DateDiff Function

https://599cd.com/tips/access/dates-...?key=AlexForum

[djclntn]

Thanks for your reply. I'm sorry, but it seems a bit complicated for my brain Thanks again!

[AlexHedley]

So how are you storing this information?
Is it like a time sheet and you are inputting each day they work?

[djclntn]

"Are you inputting each day they work" -- Yes.

[AlexHedley]

Do you know them in advance or on the day they are working?
Will there be future dates included?

For example
If I worked on Friday and then I worked on Sunday you would like the calculation to show?

[djclntn]

No, if you worked on Friday 11/29/2013 then you worked on Sunday, 12/1/2013 it'll tell me on "12/1/2013" Record/entry the number of days you last worked -- 2-days ago.

[AlexHedley]

You can use the following Query to get the last two Records.

SELECT TOP 2 Table.EDate
FROM Table
WHERE EmployeeID=y
ORDER BY Table.EDate DESC;

You could then work out the difference between the two.