I am using the following code to extract data from a table: <BR><BR>rs_DFCast.OPEN "SELECT * FROM tbl_Detail_Forecast WHERE DFCast_KDate = &#039;" & Date() & "&#039; AND DFCast_Area = &#039;" & location & "&#039; ORDER BY DFCast_Zone", connMetris, adOpenKeySet, adLockOptimistic <BR><BR>I realise it looks quite confusing but it does work fine until I add the ORDER BY clause at the end of the SQL statement. I keep getting this error message: <BR><BR>No value given for one or more required parameters. <BR><BR>AS I say, it works fine when I run the same SQL without the ORDER BY clause. I have checked and there definitely is a field called "DFCast_Zone" so that is not the problem. Is there something obvious that I&#039;m not doing? <BR><BR>cheers