mmccarthy,
Your on the right track of what I want Thank You, however we are talking about 10,000 entries. Is there a way to total the consecutive days by EmployeeID. What I need is a list of EmployeeID that has 5 or more consecutive day absence.
TroyB
Last Activity: Oct 17 '06, 11:12 PM
Joined: Oct 17 '06
Location:
-
Need query Formula for consecutive days.
I need a query formula to total consecutive days for dates. Employees are listed each time they are absent with a new date. Is this type of calculation possible without having two date fields?
tble:
Employee ID Type of Absence Date -
Need help to get a consecutive total from date field.
I am trying to be able to get report of all "employees" that have had 5 consecutive days off from a "date" field in a current table.
Normally I would do this by adding the sum of two dates, however in this case I only have one date for each entry. Below is an example of the data table I am using to get this type of information:
John Doe 1/2/06
John Doe 1/3/06
Guy...
No activity results to display
Leave a comment: