ok my mistake I thought it happened before the fact that I added in the collection time but this is incorrect.

I found the solution to my issue but I don't...

Thank you this appears to work but I have found a new problem with the sql query even before I added collection time into the mix.

For some reason one of...

for every name there is a single collection time.

Basically what happens in this is.

At xx time a collection is done against the name.

The reason I want the collection time added...

One last question.

I want to add a join and a field from another db now.

How do I do this because I'm getting an error saying it is not a part...

thank you very much!

It was the group by that was keeping me from figuring it out.