Hi,

I m using Access 2003 as a backend for my project with ASP.
I m storing date in access (date/time format in access)
Now I am acepting two dates from two text boxes, and have to give then in my query.But I am getting error viz. "No value given for one or more required parameters."
The query is as below:
--------------------
objRSPD.open "select * from TimeSheet where teamid = " & request.form("TeamList") & " and workdate between " & request.form("dateFrm1") & " and " & request.form("dateTo1"),objConn
--------------------
Does anybody have an answer????

Hey Rupen,

What output do you get for the query if you Response.Write it?

Thanks,

Chris

In access date/time values are surrounded with # when used in queries. But you seem to be missing that.

_________________________
- Vijay G
Strive for Perfection

It is working with #.
Thanks lot!!!