I did initially leave out the additional criteria as I thought I was muddying the waters and my problem was too complex to explain. I wasn't clear enough so...

Hi rbarryyoung

Thanks for taking the time in repying. Unfortunately I'm still having problems converting your sql to a format I need.

Here is the old query which extracts future...