>Thank you. :-)
> I have done it before, that is why I saw it that way. The group by went waaaay over my head. lol.
>
The problem is, that I don't think this particular select statement will correctly return the needed data. If I were Cecil, I would examine all suggestions in the thread first.
If it's not broken, fix it until it is.
My Blog