Attached is my test database (access 2010). I managed to get my consecutive null records counted successfully based on one grouping (W/E Date), but cant figure out how to restart counting when the Employee changes.
So querry "qq2" in the attached gives me the results I want from table "test1". I'm hoping someone can help me get the similar results from table "test2" but this time, a separte count of null records for each employee.
Thanks so much!
So querry "qq2" in the attached gives me the results I want from table "test1". I'm hoping someone can help me get the similar results from table "test2" but this time, a separte count of null records for each employee.
Thanks so much!