Help with ACCESS Queries

[m3hosting]

I am using VBA ASP pages to access an ACCESS database. I am having problems using dates.

My code is as follows, indate comes from a form.

indate=trim(request.form("indate&quot)
set RS objConn.execute("Select * FROM Dumps WHERE Date = #indate#&quot

Any help would be great. This date thing is killing me.

 

[vasah20]

in your code, you aren't concat the indate field, and you're missing the = sign.

it should look like:

indate=trim(request.form("indate&quot)
set RS = objConn.execute("Select * FROM Dumps WHERE Date = #" &indate& "#&quot

Hope this clears it up for you...

 

[m3hosting]

Ok what if I want to do a range of dates. Like indate1 and indate2.

I find help your wuite refreshing. I have tried for three days to wokr this out. I am a mainframe assembler programmer.

 

[vasah20]

you could change your sql string to look like this

set RS = objConn.execute("Select * FROM Dumps WHERE Date BETWEEN #" &indate1& "# AND #" &indate2& "#")

This way, the recordset you return will be between the ranges of indate1 and indate2. There are other ways that you can do this as well, but this would be the most efficient.

Whenever you have an ASP problem, feel free to post it in this forum. Chances are, that someone here will be able to help you figure out the answer.