Hi Jasper, Well I have another error which I haven't been able to get around with a dynamic query. It's very similar to what I was doing yesterday, but I'm getting an error that I have never recieved before. The original query was SELECT RESPONSIBLE_APP, SUBMITTED_ON, ASSIGNED_GROUP FROM DEFECTS WHERE (ASSIGNED_GROUP = 'CRM') AND (RESPONSIBLE_APP = ?) order by SUBMITTED_ON this works fine. But again I wanted to add the 'ALL' option, so I added an 'All' to my dropdown parameter. My code now reads: ="SELECT RESPONSIBLE_APP, SUBMITTED_ON, ASSIGNED_GROUP FROM DEFECTS WHERE (ASSIGNED_GROUP = 'CRM')" & IIf(Parameters!ResponsibleApp.Value = "All", "", " AND RESPONSIBLE_APP = ?") & " order by SUBMITTED_ON" The strange thing is, if I select 'ALL', everything works fine, but if I select any other fields, i get the error: "Query execution failed for Dataset, No error information available: DB_E_PARAMNOTOPTIONAL(0x80040E10)." I tried replacing the '?' with 'Parameters!ResponsibleApp.Value', but got another 'invalid column name' error. See anything I'm missing ?? thanks again !