access数据中用sql语句查询，有关以日期做条件的问题。

[pb2000]

string ls_rq
ls_rq='#2005-05-01#'

select je into :ld_je from table1 where fsrq=:ls_rq;

我用该语句查询不到数据，为什么？
但是用select je into :ld_je from table1 where fsrq=#2005-05-01#;却可以查到数据，请问我在程序中该如何使用日期变量做条件查询？

[iwl]

date ld_date
ld_date=Date('2005-05-01')

select je into :ld_je from table1 where fsrq=:ld_date ;

[dancer]

string ls_rq
ls_rq='#2005-05-01#'
select je into :ld_je from table1 where fsrq=:ls_rq;

一个是string,一个是date，类型不匹配的
date ls_rq
ls_rq=date('2005-05-01')
select je into :ld_je from table1 where fsrq=:ls_rq;

[saiche05]

date ls_rq
ls_rq=date('2005-05-01')
select je into :ld_je from table1 where fsrq=:ls_rq;