Hi guys

Just learning about asp etc. I have an access db which has sales budget numbers. I have an asp page that I want to be dynamic so the user can pick a date and find out what the budget for that date (or the sum of many dates) was. (or is).

I am picking up where my predescessor left off...he had a query IN the asp like this:

"SELECT SumOfbudgetAmt FROM qryBudTotalBlock" which worked. It was basically a query of a query (qryBudTotalBlock was a query) It would put the budget numbers from the beginning of the year to the present.

Now..I want to let the user pick the dates. So I added:

"SELECT SumOfbudgetAmt FROM qryBudTotalBlock WHERE budgetDate BETWEEN ' "& Request("fromDate" )&" ' AND ' "&Request("endDate")&" ' "

and it errors. My error is:
Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

newdefault3.asp, line 250

Line 250 is simply the open statement:
rsBudBlock.Open()

I know it's really nothing with the rest of the code, because it worked with the simple query. I'm assuming I'm telling it something wrong??

Can anyone help?

Thanks
Amy

Hello,

I think for dates in Access you have to do:

"SELECT SumOfbudgetAmt FROM qryBudTotalBlock WHERE budgetDate BETWEEN #"& Request("fromDate" )&"# AND #"&Request("endDate")&"# "

Also, extra spaces between the single quote and the value could cause no results to return, as it literally looks for a space before and after, as such:

' 6/22/2004 '

Brian

Thanks

Someone else told me the same thing..but that doesn't work either. Now I get the 80040e07 error.

It just doesn't like my statement from BETWEEN on.

Just wondering...the box the user can put in the date (actually, he's forced to use the same syntax as the db)..the box is bigger than the date. Does Access try to read that as 6/21/2004spacespacespacespace? and because there is no date with spacespacespacespace after it..would that cause it to fail?

Amy

The error is usually caused by use of incorrect delimiters in your SELECT SQL query statement as mentioned in the earlier post. For Access delimiter is # for date/time field.

after your SQL statement put this code.

Response.Write(YourSQLStatementVariable)
Response.End

and post it.

Assuming I did this correctly...This popped up on my screen

SELECT SumOfbudgetAmt FROM qryBudTotalBlock WHERE budgetDate BETWEEN #6/21/2004# AND #6/22/2004#

And that's all

So that means it's getting the correct info, just not getting the sum like it should between those two dates, right?

Or am I totally going the wrong direction?

Would you post some code? inlcuing SQL for "qryBudTotalBlock "

Hi

The boss man just changed his mind on what he wants done..so I'm sure I'll run into other problems along the way, but for now...that problem is solved.

Thanks to all those who responded!

Amy