Hi, everyone,

    I was trying to compare two dates in my SQL statement. The system 

keeps give me error: "Microsoft JET Database Engine (0x80040E10)

No value given for one or more required parameters". The WHERE statement 

in my SQL code as following:

WHERE [Client Table].CliIntakeDate >= strStartDate AND [Client 

Table].CliIntakeDate <=strEndDate



strStarDate and strEndDate both are reading from user as following:

strStarDate=request.form("startDate")

strEndDate=request.form("endDate")



Is anyone could help me out? Thanks a lot!



Kai

Maybe,

Use WHERE BETWEEN date1 AND date2



Also are you building you sql statement properly



sSql = sSql & " WHERE [Client Table].CliIntakeDate >= #" & strStartDate 

& "# AND [Client 

Table].CliIntakeDate <= #" & strEndDate & "#"

Access uses #'s around date values



hope this helps.





> Hi, everyone,

>     I was trying to compare two dates in my SQL statement. The system 

> keeps give me error: "Microsoft JET Database Engine (0x80040E10)

> No value given for one or more required parameters". The WHERE statement 

> in my SQL code as following:

WHERE [Client Table].CliIntakeDate >= strStartDate AND [Client 

Table].CliIntakeDate <=strEndDate

> 

> strStarDate and strEndDate both are reading from user as following:

> strStarDate=request.form("startDate")

> strEndDate=request.form("endDate")

> 

> Is anyone could help me out? Thanks a lot!

> 

> Kai

Thanks for ur help, it works for me.



Kai