I don't know if I should laugh or cry after looking at this code. This could not have been written by a human right? Anyway here it is, consider it a teaser. If you want to torture yourself and look at the whole query then go here: http://www.tek-tips.com/viewthread.cfm?qid=1421304&page=1   HAVING (((1 = 1)AND (PP.Created >= ...