[thelist] ASP & Access - Using the same variable twice

Ok, I got the query to work the way I wanted it to now... finally... :)

Anway, it goes like this:

SQL=("SELECT * FROM t_datetable WHERE dDATE<=(DateAdd('H',13,Now())) ORDER
BY dDATE DESC")

So basically I have the info in my databse set with dates and times, and
this query will pull out only the stuff from todays date and previous dates.

Thanks for all the help!

Christian Anderson
Email: chris@photokyo.com
Cell/Keitai: digger@ezj.ido.ne.jp
URL: http://www.photokyo.com