Well, a staff member just didn't have a shift logged on that date - (usually an admin error explains this - someone forgot to enter them). But the thing...

Perhaps one minor tweak is in order, which I hope you can help with. If there is no shift on a day, I want the period/episode to continue. Err...

Here's some...

Oh. Got a bit stuck - when there are two shifts for the same person on a day. This forces a new period, as in the test data/code below. have...

I loved your "Hoo-uh" bit - was just watching Black Hawk Down again last night...

Golly, thanks for this - saved me a lot of time. I read Jeff's article and was just beginning to understand bits of it when my daughter cam home from...

Well, thanks. I wish I'd been able to find this earlier. As you cleverly noted - I really want to do this myself - so am grateful for the steer.

Regards,...

Thanks Lynn, for your direction and advice too ! I'm very new to SQL and the basic syntax is about all I can get my head around at present. As...

Thanks to you all for your comments and feedback. Jeff, I understood the purpose of your excellent article - but I'd probably have to use a very simple syntax (that...

Thanks. I;d read this already but it didn't help - I'd implemented the triangular join type mechanism (I think) to create a running total - but this part I'm stuck...

I might be able to put up some test data when back in the office, but was wonder from a syntactical perspective if this was possible.

G

Genius ! Thanks very much !

Amusing ! Well thanks anyway for your humane comments (I do feel a bit quilty nonetheless as I'm sure I could have described this problem better). Anyway, I did receive...

Hmm yes, you are right, I really want to swap those rows at query runtime, not delete them. I think I have enough on the self-join angle to sort this...

I didn't design the table - although I'm sure the developers who did would appreciate those design comments. If they were still alive. Often, we just have to work with...

That's another one for me to try - thanks all !

Greg