Hi Arnelgp,It was the fldChangeDate I kept getting syntax errors with, in the end I ended up using nectorch's answer just because the layout was a lot easier to understand in the SQL query - I was getting confused as to how to put all that into one string, my vba not that good.