Hola Senor en Senora.

I have a question.

I wanted to ask about SQL conditions. My ASP collects input from User where the User selects a table from a drop down list. There are also 2 textboxes that takes in date from a pop-up calendar. These 2 textboxes are named dateOne and dateTwo respectively.

I can view the ASP page but when I select the date range & clicks Submit, I can only see the table's field columns. I don't know what went wrong. I do hope you guys could help me out. My SQL statement is as follows:
"SELECT * FROM " & Request.Form("tblInfo") & " WHERE reportdate BETWEEN # " & Request.Form("dateOne") & " # AND # " & Request.Form("dateTwo") & " # "

Are the delimiters correct? But why no values are displayed when User chooses the date range?? I welcome all opinions & ideas & also tips...

delimeters are correct for Access.

write out the sql statement before the db call it looks like you have spaces between "#" and the date.

Hole Senor. I have solved my error. Gracias Senor for helping me out.

It seems the problem lies in the display of the table. I've misplaced the tags <tr>..</tr>. And that's why I cannot print out the table. Gosh. I felt so stupefied. But luckily I have solved my problem. Pheewwwwwww..