Whooops! :blush:

Thanks for the advice.

Lynn,

That seems to work like a charm.

Thanks taking the time to produce a working example, its really appreciated.

I will do some real world testing on it shortly to see how...

Lynn Pettis (3/25/2010)

---

Thank you. I won't be able to spend much time on this at the moment, but hopefully someone else will look at the problem, or I will...

Lynn,

We are using 2000, 2005 and 2008, so require compatibility down to 2000 level.

Many thanks

Lynn,

There is one other requirement that I had totally forgot to include in the original question.

The order of the parent items should be by SortID as this will always be...

Like I said, I knew there was a simple solution 🙂

(I was certain I had tried that!!! Maybe the age is starting to show .....!)

Many thanks Lynn

Thanks for the example, but I think you have missed the point that my date isnt one standard datetime field, its actually made up

of two columns, date and time. They...

GSquared (9/8/2009)

---

I was going to suggest subtracting five hours from the time to get the appropriate date, but I see that Michael beat me to it.

The thing to keep in...