gone dranock
Thanks you for your reply.
But how?
My Query with manually picked dates (in the wizzard) reads:
"SELECT Date AS XLABEL, Minutes AS YVALUE FROM Stats WHERE ID= ? AND Date >= #07-09-2010# AND Date <= #07-12-2010#"
Now I would like to replace #07-09-2010# and #07-12-2010# with the values(variable) in the url (mysite2.asp?ID=4&StartDate=10-14-2010&EndDate=10-23-2010)
for StartDate and EndDate. These variable are passed into the url from a form (on prevoius page (.../mysite1.asp)).
I though of something like this:
Dim WADWC__ParamStartDate
WADWC__ParamStartDate = Request.QueryString("StartDate")
Dim WADWC__ParamEndDate
WADWC__ParamEndDate = Request.QueryString("EndDate")
SELECT Date AS XLABEL, Minutes AS YVALUE FROM Stats WHERE ID = ? AND Date >= @WADWC__ParamStartDate AND Date <= @WADWC__ParamEndDate "
But It doesn't work like this. Thanks for all your help!