Query a range of dates from Access
Gene says:
Quote:
>I am looking for a way to get a range of dates from an Access data base.
>Does anyone does how to do this?
Really not a
VBScript question, but I'll wrap it in some VBScript to
justify it.
SQL = "SELECT * FROM TableName " & _
"WHERE DateField < #" & MaxDate & "# AND " & _
"DateField > #" & MinDate & "#"
Set CN = Server.CreateObject("ADODB.Connection")
CN.Open dbConnectionString
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open SQL, CN, 0, 3
--
Randem
MCP+I / MCSE
