Allrite - I think, I have resolved it- I have written quite a long stored procedure to resolve it.

I am sure its not the best way to do it...

Ah, thank you for all this. I was able to modify it for groups but It still does not give the correct output -

the sample data i posted in...

Thank you - it looks good and looks to meet what...

Evil Kraig F (4/4/2012)

---

Let me rephrase the question as to how I understand it and it might help.

Basically, what you're looking to do is take the existing list, re-order it...

Lynn Pettis (4/4/2012)

---

aptlogix (4/4/2012)

---

Lynn Pettis (4/4/2012)

---

One, for what time period is the report run? Past 7 days, since the beginning of the term, etc.

When one sees consecutive days, one is...

Lynn Pettis (4/4/2012)

---

One, for what time period is the report run? Past 7 days, since the beginning of the term, etc.

When one sees consecutive days, one is usually refering to...

Stuart Davies (4/4/2012)

---

I appreciate the question as it stands,

but how in the real world do you want to handle absences on a Friday and again on a Monday - are...