Hola senora en senor.

At first, I have an error message that says : (0x80040E10) No Value given for one or more parameters.
And then, when I tweak the codes abit here & there, a second error message appears:
(0x80040E10) Syntax error in string in query expression 'reportdate'
Currently, my ASP page can display all table names that is retrieved from a table 't_tablenames' & the respective tables sits in their own database. For eg. 2004.mdb , 2005.mdb
Apart from that, I also want to implement a date range input where the User can select the date range. For eg. 12/02/2004 - 14/02/2004
I have actually tried to do the date range input & executing it upon clicking the "Submit" button but it seems that only the field columns are displayed. Is there something wrong with my SQL statement or my ASP codes?

SQL : "SELECT * FROM " & Request.Form("tblInfo") & " WHERE reportdate BETWEEN " & Request.Form("box1") & " AND " & Request.Form("box2")

All my tables have a field name [reportdate] & its data type is in Long Date(Eg. dd/mm/yyyy )
I'm not really sure where exactly is my mistake. Do hope you could point it out to me.

it means that one of the variables you are using is empty

Do some basic debugging and response.write out the value of the SQL query before calling it and post the result

(BTW: This should be in the asp forum)

Hola senor.
Sorry. But I had thought that DB related questions should be posted here. Erm. Maybe I'm wrong. I have already Response.Write out my values but I cannot seem to find the error. I also had already searched & tweak my codes but I still end up confused. The SQL turns out ok to me:
SELECT * FROM Consolidatedblacklist WHERE reportdate BETWEEN 12/02/2004 AND 13/02/2004

Is that correct senor?

No the error number reported is an ASP error code.
The dates should be in quotes (') and Access may need date literal delimiters (#) around the dates.