Recent content by opperman.eric

Thanx. Limiting it to one is not feasible, as I need to run the report for between 600 and 1000 staff. At any given time 50+ are encroaching the maximum allowable consecutive days worked. I wouldn't know which 50, hence this query. It works. I can simply continue to run it on a machine with...

Thanx Galaxiom. I like the function because it only gives me the number of consecutive days worked up until now. I.e. if an employee worked 100 days up to the day before yesterday, then had a day off, and worked again yesterday, I am only interested in an answer of one. Since he had the day off...

Hi, can anyone help? The above works well in Access 2010, but when using the exact same data source, in 2013, the results seem to be limited to "16", even for employees with more. (In those cases, the correct number of days are returned in Access 2010) I have checked the number of iterations...

Thanx! Looks good!

Hi The table name is ImportData, and the field names are EmpNumber and StartDate. Thanx!

Hi I have a table of employees, and dates they worked on. These are seasonal employees who want to get in as many days as possible before the season ends, but regulation states they must take a compulsory rest day after x days. So I need to create a query that can return the list of employees...

Hi Im currently working on two small projects and getting stuck here and there. I would say that I have intermediate skills. Any help would be appreciated :) Cheers Eric