Yes, the guessing machine is working (btw, sorry, it's very late where I am so very tired) the results I am after is all values between a given range of intervals for every distinct pollDate which falls between a pollDate range. There are other complicating factors to what I am after but would rather progress to those after getting the basic query out of the way. Cheers