This works fine in Command window. I have used this as Local view in my report

SELECT Request.iid, Request.dtoday, Request.dtois, Request.creqfrom,;
Request.creqdeptt, Request.creqdesc, Request.dneeded, Request.csubmtedby,;
Request.ccomplby, Request.dcompltd, Request.cstatus;
FROM isapp!request;
WHERE Request.dtoday >= ?vp_dFinishFrom;
AND Request.dtoday <= ?vp_dFinishTo;
AND Request.cstatus IN ("&vp_cStatusField")

As is clear from the IN creteria, it puts the double quotes around &vp_cStatusField. It again gives me blank recordset. It puts "" automatically.

thanks