Thanks Gail and Alexander...that has got it!

I REALLY appreciate the assistance.

Have a great day!

Hi Alexander,

I tried that and got the following error:

Microsoft VBScript compilation error '800a03ee'

Expected ')'

The arrow pointed to just after the first set of double quotes on :

AND (LocationID...

Hi Alexander,

I REALLY appreciate the help...thanks!

I replaced the double quotes with singles ... as in ...

AND (LocationID = " & Session("LocationID") & ")

became:

AND (LocationID = ' & Session("LocationID") &...

Hi Alexander,

I tried that and got the following error:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

rs.Open "SELECT varible1, variable2, eventdate FROM dbo.FullDump WHERE (eventdate >= { fn NOW()...