Date searches in Access

[Silenus69]

I am constructing an ASP application that will allow users to pull data from a specific date range in an access database. I am using the following SQL Query:

adorecord.open "select * from apsqa",adoconn
adorecord.filter= &quot;s2>= #&quot; & std & &quot;# AND s2<= #&quot; & edd & &quot;#&quot;
std = the beginning date
edd = ending date
s2 is the date field in the database table
Both edd and stm are DIM'ed as date

When I run this query, It return ALL dates, even those that lie outside the range....Any suggestions?

Dan

 

[AccessAce]

Try this

adorecord.open &quot;select * from apsqa where s2 between #&quot; & std & &quot;# AND #&quot; & edd & &quot;#&quot;,adoconn

 

[Silenus69]

That worked!! Thanks!!!!